How to Select the Entire Spreadsheet 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, 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.

how to select the entire spreadsheet in excel 2013



Alternatively you can click any cell in the spreadsheet, then press the Ctrl + A keys on your keyboard.

how to select all of the cells in excel 2013

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. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.