Scrolling through thousands of rows is painful. Ctrl with an arrow key jumps straight to the edge of your data in any direction.
Step by step
- Click a cell in the column you want to navigate.
- Press Ctrl+Down Arrow to jump to the last filled cell before a gap.
- Use Ctrl+Up, Left or Right Arrow to jump in other directions.
- Press Ctrl+End to go to the last used cell on the whole sheet, or Ctrl+Home to return to A1.
Tips & troubleshooting
- Add Shift (Ctrl+Shift+Down Arrow) to select every cell from where you are to the end of the data.
- Blank cells stop the jump. Press the shortcut again to continue to the next block.
How the jump works
Ctrl+Arrow moves to the edge of the current block of filled cells. From inside data it stops at the last filled cell before a blank. From a blank cell it jumps to the next filled one. If there is nothing more in that direction it goes all the way to the edge of the worksheet: row 1,048,576 or column XFD. If you land there by accident, Ctrl+Up Arrow or Ctrl+Home takes you back.
The related shortcuts worth knowing
- Ctrl+End goes to the last used cell on the sheet, the bottom-right corner of everything Excel thinks is in use.
- Ctrl+Home returns to A1, or to the first cell below and right of frozen panes.
- Ctrl+Shift+Arrow selects as it jumps, and Ctrl+Shift+End selects from the active cell to the last used cell.
- Ctrl+Backspace scrolls the window back to the active cell when you have wandered away with the mouse wheel.
- Ctrl+G opens Go To. Type a reference such as A5000 and press Enter.
Gaps in the data
A column with blanks makes Ctrl+Down Arrow stop at every gap. Two ways round it: move to a column that has no blanks, such as an ID column, jump down there and then move across; or go to the very bottom of the sheet with Ctrl+Down Arrow repeatedly and come back up once with Ctrl+Up Arrow, which lands on the last filled cell however many gaps lie above it.
When Ctrl+End goes too far
If Ctrl+End lands hundreds of rows below your data, Excel is remembering cells that once held content or still carry formatting. Select the empty rows below your data, right-click and choose Delete, do the same for empty columns to the right, then save the workbook. The used range resets and the file is often smaller as well.
On a Mac
In Excel for Mac use Cmd+Arrow key to jump to the edge of the data, and Control+End for the last used cell.