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 + *.
Selecting a Whole Spreadsheet in Excel
posted in: Shortcut of the Week
0
Leave a Reply