Excel shortcut to select the entire sheet
Select the entire sheet : Ctrl & A
When the starting point is a blank cell, the entire sheet is selected
When the starting point is a cell inside a table for example, only the table is selected.
Am I right?
When the starting point is a blank cell, the entire sheet is selected
When the starting point is a cell inside a table for example, only the table is selected.
Am I right?
1 answers ( 0 marked as helpful)
Hi Marlyse,
Good to hear from you!
Yes, you are right. Ctrl + A works at different levels precisely as you described. It basically goes to select the nearest non-blank cells. If you are inside a table, the whole table will be selected. Alternatively, in an empty sheet Ctrl + A will allow you to select the entire sheet.
Best,
Ned
Good to hear from you!
Yes, you are right. Ctrl + A works at different levels precisely as you described. It basically goes to select the nearest non-blank cells. If you are inside a table, the whole table will be selected. Alternatively, in an empty sheet Ctrl + A will allow you to select the entire sheet.
Best,
Ned