Selecting a Whole Spreadsheet in Excel

The general Select All shortcut is used in Excel spreadsheets.
But it behaves differently depending on where you are in a spreadsheet.
If you are on a cell within a block of data, Control + A will just select the block of data.
If you are between two blocks of data, Control + A will select both blocks of data.
If you are on a cell which is away from any block of data (to the right or below), Control + A will select the whole spreadsheet, including a great number of empty cells.
It’s all to do with the number of empty cells between blocks of data in a spreadsheet.
There are also two other shortcuts that behave in a similar way, Control + Shift + Spacebar and Control + Shift + *.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.