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.

← All Excel shortcuts

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.

WindowsCtrl+End
MacControl+Fn+→

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.

English (US)Ctrl+End · on laptops with Fn: Ctrl+Fn+End
HrvatskiCtrl+End · on laptops with Fn: Ctrl+Fn+End
DeutschStrg+Ende · on laptops with Fn: Strg+Fn+Ende
EspañolCtrl+Fin · on laptops with Fn: Ctrl+Fn+Fin
FrançaisCtrl+Fin · on laptops with Fn: Ctrl+Fn+Fin
PortuguêsCtrl+End · on laptops with Fn: Ctrl+Fn+End
ItalianoCtrl+Fine · on laptops with Fn: Ctrl+Fn+Fine
TürkçeCtrl+End · on laptops with Fn: Ctrl+Fn+End
Bahasa IndonesiaCtrl+End · on laptops with Fn: Ctrl+Fn+End
PolskiCtrl+End · on laptops with Fn: Ctrl+Fn+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

  1. Click any cell, for example the first one.
  2. Press Ctrl + End. On many laptops hold Fn too: Ctrl + Fn + End.
  3. You land in the last cell of the data. Press Ctrl + Home to come back to A1.
Good to know: Add Shift to select while you jump: Ctrl + Shift + End selects everything from the active cell to the last cell of the data.

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.

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.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games