The Ctrl + A guide
Inside a block of data, Ctrl+A (⌘+A on a Mac) selects that block. Press it again, or press it in an empty cell, and it selects the whole sheet.
What "all" means
Excel's first Ctrl+A selects the current region: the cells around the active cell that touch each other, up to the first completely empty row and column on every side. A note two columns to the right isn't part of it; a table split by an empty row is two regions.
A second press selects the whole sheet. So does the first press when the active cell is empty and nothing touches it, and so does the corner button left of the A column header.
When the whole table isn't selected
An empty row or column inside the data cuts the region short: Ctrl+A stops there. Fill the gap or delete the empty row, or select the table yourself: click its first cell and press Ctrl+Shift+End.
In a formatted table
Microsoft's rule for Excel tables: the first Ctrl+A selects the table's data, and the second the whole table, headers included.
Common mistakes
- Pressing it in an empty cell. The whole sheet gets selected, and a format or a delete hits a million rows.
- Pressing it twice by habit. The second press throws away the table selection.
- Expecting it to select text in a cell. While you're editing a cell, Ctrl+A works on the formula, not the sheet.
FAQ
- What is the shortcut to select all in Excel?
- Ctrl+A on Windows, Command+A on a Mac. Inside data it selects the current block; pressed again, the whole sheet. Ctrl+Shift+Space also selects the sheet.
- Why does Ctrl+A select the whole sheet instead of my table?
- The active cell was empty and not touching the table, or you pressed it twice. Click a cell inside the table and press it once.
- Why does Ctrl+A not select all my data?
- An empty row or column splits the data into separate blocks, and Ctrl+A stops at it. Remove the gap, or select the range from its first cell with Ctrl+Shift+End.



































































