Excel · Jump to the last used cell

Navigation

Windows · Linux

Ctrl+End

Mac

Ctrl+End

Both systems use the same combination.

Jumps to the last cell the sheet counts as used; if your data ends at row 100 but this lands on row 50000, you have just found why the file is bloated.

Group: Navigation
Keys held: 2

Excel diverges most on the Mac. F4 for absolute references is Cmd+T there, and a few Ctrl combinations stay Ctrl rather than becoming Cmd.

Reading the key names

Keys joined by + are pressed together: Ctrl+Shift+P means hold Ctrl and Shift, then P.
On a Mac, Cmd is ⌘, Option is ⌥ (labelled Alt on some keyboards), Control is ⌃ and Shift is ⇧.
Windows Ctrl usually becomes Cmd on a Mac, but not always — this reference lists both combinations separately.
With a Korean, Japanese or Chinese input method active, shortcuts built on letter keys may not fire. Switch to Latin input and try again.
When a combination does nothing, another program has often claimed it as a global shortcut first.

Common questions

Q. What is the shortcut for Jump to the last used cell in Excel?

Jumps to the last cell the sheet counts as used; if your data ends at row 100 but this lands on row 50000, you have just found why the file is bloated. It is Ctrl+End on Windows and Ctrl+End on a Mac.

Q. Is it the same on Windows and Mac?

Yes, Ctrl+End on both.

Q. How many keys is that?

2 pressed together. The combination sits under Navigation in Excel.

Shortcuts nearby

Jump to A1Ctrl+HomeGo to the next sheetCtrl+PageDownGo to the previous sheetCtrl+PageUpInsert a new sheetShift+F11Insert cells, rows or columnsCtrl+Shift+PlusDelete cells, rows or columnsCtrl+MinusHide the selected rowsCtrl+9Hide the selected columnsCtrl+0