The Ctrl + arrow guide
Ctrl+↓ (⌘+↓ on a Mac) jumps from a filled cell to the last filled cell before a gap. Ctrl+→, ← and ↑ do the same in their direction. A blank cell stops the jump; from a blank cell it goes to the next filled one.
The rule
- On a filled cell with a filled neighbour, the jump runs to the last filled cell in that direction.
- On a filled cell with an empty neighbour, or on an empty cell, it runs to the next filled cell.
- If nothing is filled in that direction, it runs to the edge of the sheet: row 1,048,576 or column XFD. Ctrl+↑ brings you back.
Pick a column without gaps
To reach the last row of a table, jump down a column that is filled all the way, like an ID or order number, rather than one with blanks such as notes or amounts still to come. Then Ctrl+→ runs along the last row to the column you need.
Related keys
- Ctrl+Shift+arrow selects everything on the way: select to the end of a column.
- Ctrl+Home goes to A1, Ctrl+End to the last used cell of the sheet.
On a Mac, Microsoft lists ⌘+arrow. ⌃+arrow is taken by macOS for switching desktops and Mission Control.
Common mistakes
- Stopping at a gap and taking it for the end. Look at the row number. Press the shortcut again to carry on.
- Landing a million rows down. You started in an empty column. Ctrl+↑, then move into the data.
- Pressing the arrow forty times. It works, it just takes forty times as long.
FAQ
- What is the shortcut to go to the last row in Excel?
- Ctrl+Down arrow on Windows, Command+Down arrow on a Mac. It jumps to the last filled cell before a blank one in that column.
- Why does Ctrl+Down stop before the end of my data?
- There is a blank cell in the column. The jump stops at the last filled cell before it. Press it again to continue, or jump down a column without blanks.
- Why does Ctrl+Down go to row 1048576?
- The column has nothing below the active cell, so Excel runs to the bottom of the sheet. Press Ctrl+Up to come back.



































































