ShortcutdrillExcel shortcuts / navigation / Jump back up to the header
Jump back up to the header in Excel: Ctrl+Up arrow (Mac: Cmd+Up arrow)
| Windows | Ctrl+Up arrow |
|---|---|
| Mac | Cmd+Up arrow |
| Group | navigation |
Drill: Back up to the header. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Up moves to the first filled cell above, usually the header of the column. After a Ctrl+Down to check the bottom of a column, Ctrl+Up returns you in one press.
The common mistake
Pressing it from the header itself: there is nothing above, so you land in row 1 of an empty area.
Related shortcuts
- Cross a gap between two blocks Ctrl+Down arrow, twice
- Go to a cell by address Ctrl+G, type the address, Enter
- Jump to a named range F5, pick the name, Enter
- Jump to the cells a formula uses Ctrl+[
- Return to where you came from F5, Enter
- The printable cheat sheet
Questions
How do I check the top and bottom of a column quickly?
Ctrl+Down then Ctrl+Up. Two presses show both ends of the data without scrolling.
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