How to Select All in Excel 2013
Cell selection in Microsoft Excel can take a variety of forms, and you may already be familiar with selecting a single cell, a row, a column, or even a range of cells. You might even know how to expand all rows in Excel so that you can see your data more easily. 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 decision 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 (Guide with Pictures)
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. I personally prefer the keyboard shortcut method of how to select entire spreadsheet in Excel, but both options are fast and effective. If this is something that you find yourself doing on a regular basis then you will discover which option works best for you. many other applications can utilize the select all keyboard shortcut, too. For example, you can press Ctrl + A on your keyboard when a Word document is open, and it will select everything in the document. 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.
Additional Sources
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. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
