Learn › Excel › Jump to the last cell
Excel last cell shortcut: Ctrl + End
Jump to the bottom right corner of your data, the last cell in use.
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 + End jumps to the last cell of the used range, the bottom right corner of your data. It shows where your data really ends, even in a sheet with thousands of rows.
When to use it
Use it to find the end of a long table, or to find a stray cell far from your data. If it lands on an empty cell, that area was used before and then cleared.
How to do it
- Click any cell, for example the first one.
- Press Ctrl + End. On many laptops hold Fn too: Ctrl + Fn + End.
- You land in the last cell of the data. Press Ctrl + Home to come back to A1.
A quick example
In a sales table with 40 rows and 12 columns, click A1 and press Ctrl + End: you land in L41, the last cell of the data.
Ctrl + End and Ctrl + Down arrow
Ctrl + Down arrow jumps to the end of one column, while Ctrl + End jumps to the last cell of the whole sheet. Ctrl + Home goes back to A1.
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.
- Your laptop needs Fn: on many laptops the End key works only together with Fn, so press Ctrl + Fn + End.
- It lands on an empty cell far away: that area was used before, 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 End key: hold Fn and press the right arrow.
Quick answers
What is the shortcut to go to the last cell in Excel?
Press Ctrl + End. It takes you to the bottom right corner of your data. On many laptops press Ctrl + Fn + End.
Why does Ctrl + End go to an empty cell?
That area was used earlier and then cleared. Delete the empty rows and columns and save the file.
How do I select to the last cell?
Press Ctrl + Shift + End. It selects from the active cell to the last cell of the data.

