ShortcutdrillExcel shortcuts / navigation / Jump to the edge of the data
Jump to the edge of the data in Excel: Ctrl+Arrow (Mac: Cmd+Arrow)
| Windows | Ctrl+Arrow |
|---|---|
| Mac | Cmd+Arrow |
| Group | navigation |
Drill: Jump to the bottom. Free, no sign-up.
What it does and when to use it
Ctrl with an arrow key moves the active cell to the last filled cell in that direction. If the next cell is blank it jumps to the next filled cell instead. On a sheet with thousands of rows it replaces scrolling entirely.
The common mistake
Pressing it in a column with a gap: the jump stops at the gap, not at the bottom. Press again to cross it, and use the stop as a free check for holes in the data.
Related shortcuts
- Jump to the last column of a row Ctrl+Right arrow
- Return to cell A1 Ctrl+Home
- Jump back up to the header Ctrl+Up arrow
- Go to the start of the row Home
- Go to the last used cell Ctrl+End
- The printable cheat sheet
Questions
Why does Ctrl+Down go to row 1048576?
There was nothing below the active cell, so Excel jumped to the last row of the sheet. Press Ctrl+Up to come back, or start from a cell that has data under it.
What is Ctrl+Arrow on a Mac?
Cmd+Arrow. Ctrl+Arrow on a Mac switches desktops unless you change the Mission Control shortcuts.
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