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.

← 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+↓
Mac⌘+↓

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+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+End · Ctrl+Home · on laptops with Fn: Ctrl+Fn+End · Ctrl+Fn+Home
HrvatskiCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+End · Ctrl+Home · on laptops with Fn: Ctrl+Fn+End · Ctrl+Fn+Home
DeutschStrg+↓ · Strg+→ · Strg+↑ · Strg+← · Strg+Ende · Strg+Pos1 · on laptops with Fn: Strg+Fn+Ende · Strg+Fn+Pos1
EspañolCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+Fin · Ctrl+Inicio · on laptops with Fn: Ctrl+Fn+Fin · Ctrl+Fn+Inicio
FrançaisCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+Fin · Ctrl+Début · on laptops with Fn: Ctrl+Fn+Fin · Ctrl+Fn+Début
PortuguêsCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+End · Ctrl+Home · on laptops with Fn: Ctrl+Fn+End · Ctrl+Fn+Home
ItalianoCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+Fine · Ctrl+Home · on laptops with Fn: Ctrl+Fn+Fine · Ctrl+Fn+Home
TürkçeCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+End · Ctrl+Home · on laptops with Fn: Ctrl+Fn+End · Ctrl+Fn+Home
Bahasa IndonesiaCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+End · Ctrl+Home · on laptops with Fn: Ctrl+Fn+End · Ctrl+Fn+Home
PolskiCtrl+↓ · Ctrl+→ · Ctrl+↑ · Ctrl+← · Ctrl+End · Ctrl+Home · on laptops with Fn: Ctrl+Fn+End · Ctrl+Fn+Home

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

  1. Click a cell in your table, for example the first cell.
  2. 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).
  3. 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.
Good to know: The jump stops at the first empty cell. If your column has a gap, Ctrl + Down arrow lands on the cell just before the gap, and a second press jumps to the next block. To jump and select at the same time, hold Shift as well: Ctrl + Shift + Down arrow.

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.

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.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games