ShortcutdrillExcel shortcuts / selection / Select back to A1
Select back to A1 in Excel: Ctrl+Shift+Home (Mac: Fn+Cmd+Shift+Left arrow)
| Windows | Ctrl+Shift+Home |
|---|---|
| Mac | Fn+Cmd+Shift+Left arrow |
| Group | selection |
Drill: Select back to A1. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Shift+Home selects from the active cell back to A1. From the bottom-right corner of a table it selects the whole table, headers included.
The common mistake
Starting outside the data: the selection includes empty columns to the left.
Related shortcuts
- Select a column of data Ctrl+Shift+Down arrow
- Select across a row Ctrl+Shift+Right arrow
- Select the whole row Shift+Space
- Select the whole column Ctrl+Space
- Select the current table Ctrl+A
- The printable cheat sheet
Questions
How do I select a whole table from its bottom-right corner?
Ctrl+Shift+Home. Or Ctrl+A from inside it, which works from any cell.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill