Learn › Excel › Jump to the edge of your data
Excel jump shortcuts: Ctrl + Arrow, Ctrl + Home, Ctrl + End
Jump to the last row or column of your data with Ctrl + Arrow, and to the last or first cell with Ctrl + End and Ctrl + Home.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
Laptops with an Fn key: the F keys (F2, F4, F5, F11...) usually need Fn pressed together with them, for example Fn + F4. If Fn Lock is on, they work without Fn. The same goes for Home and End.
What it does
Ctrl + an arrow key jumps from the active cell to the edge of the block of data it is in, so you reach the last row or column in one press. Ctrl + End jumps to the last cell that holds data, and Ctrl + Home jumps back to cell A1. No scrolling is needed, even in a sheet with thousands of rows.
When to use it
Use it when a table is too long to scroll: Ctrl + Down arrow finds the last row, Ctrl + Right arrow the last column, and Ctrl + Up or Ctrl + Left bring you back to the headers. Ctrl + End shows where your data really ends, which helps to find a stray cell far away.
How to do it
- Click a cell in your table, for example the first cell.
- Press Ctrl + Down arrow to jump to the last row, or Ctrl + Right arrow to jump to the last column (on a Mac: Command + arrow).
- Press Ctrl + Up arrow or Ctrl + Left arrow to come back, Ctrl + End to reach the last cell of the data, and Ctrl + Home to return to A1.
A quick example
In a sales table with 40 rows and 12 columns, click A1 and press Ctrl + Down arrow: you land on the last row, A41. Press Ctrl + Right arrow and you reach the last column, L41. Ctrl + Up arrow takes you to L1, and Ctrl + Left arrow back to A1. Ctrl + End jumps to L41, the last cell of the data, and Ctrl + Home returns to A1.
Ctrl + Arrow, Ctrl + End and Ctrl + Home
Ctrl + Arrow moves to the edge of the block you are in, Ctrl + End goes to the last used cell of the whole sheet, and Ctrl + Home goes to A1. Add Shift to any of them to select instead of just jump. The cell you reach with Ctrl + End can be an empty one, if cells below or beside your data were used earlier and then cleared.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar or a search box.
- Ctrl + Down arrow stops in the middle of your data: there is an empty cell in the column. Press it again to jump to the next block.
- Ctrl + End goes to an empty cell far away: that area was used earlier, for example it was formatted or typed in and then cleared. Delete those empty rows and columns and save the file.
- Your laptop has no Home or End key: hold Fn and press the left or right arrow.
- On a Mac use Command + arrow keys for the jumps.
Quick answers
What is the shortcut to go to the last row in Excel?
Click a cell in the column and press Ctrl + Down arrow. You jump to the last filled cell of the column. Press it again to reach the very last row of the sheet.
What is the shortcut to go to the top of the sheet?
Press Ctrl + Home to go to A1, or Ctrl + Up arrow to jump to the first row of the column.
How do I jump to the last cell with data?
Press Ctrl + End. It takes you to the last cell of the used range, the bottom right corner of your data.
How do I select all the way to the end of the data?
Hold Shift as well: Ctrl + Shift + Down arrow selects from the active cell to the last filled cell of the column.

