Cell selection in Microsoft Excel can take a variety of forms, and you may already be familiar with selecting a single cell, or a row, column, or even a range of cells. But selecting and modifying small sections of your spreadsheet can be tedious when you have to make large changes, so you might be looking for a way to select the entire spreadsheet in Excel 2013.
Luckily you have a couple of different options that can help you accomplish this task, and the decisions to use one or the other is entirely up to you. Continue reading below to see how you can easily and quickly select an entire spreadsheet’s cells with just a couple of actions.
How to Select All of the Cells in Excel 2013
This guide will show you a couple of different methods for selecting all of the cells within a worksheet in Excel 2013. These steps will also let you select all of the cells in Excel 2016, as well as most older versions of the program.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Click the gray triangle above the row A heading and to the left of the column 1 heading.
Alternatively you can click any cell in the spreadsheet, then press the Ctrl + A keys on your keyboard.
Are you getting frustrated trying to make Excel print your spreadsheets effectively? Read our Excel printing guide for some tips on settings that you can change and adjustment you can make which will dramatically improve the quality of your printed spreadsheets.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.