Learn › Excel › Jump to the top of the data

Excel jump up shortcut: Ctrl + ↑

Jump to the first filled cell above you, the top of your column, in one press.

← 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.

English (US)Ctrl+↑
HrvatskiCtrl+↑
DeutschStrg+↑
EspañolCtrl+↑
FrançaisCtrl+↑
PortuguêsCtrl+↑
ItalianoCtrl+↑
TürkçeCtrl+↑
Bahasa IndonesiaCtrl+↑
PolskiCtrl+↑

What it does

Ctrl + Up arrow jumps from the active cell to the first filled cell of the column, the top edge of your data. You reach the header without scrolling up.

When to use it

Use it in a long table to get back to the headers fast. It stops at the first empty cell, so a gap in the column stops the jump early.

How to do it

  1. Click a cell low in the column.
  2. Press Ctrl + Up arrow (on a Mac: Command + Up arrow).
  3. You land on the first row of the data. Press Ctrl + Down arrow to go back to the bottom.
Good to know: Add Shift to select while you jump: Ctrl + Shift + Up arrow selects from the active cell up to the top of the data.

A quick example

In a sales table with 40 rows, click A20 and press Ctrl + Up arrow: you land in A1, the header.

Ctrl + Up arrow and the other jumps

Ctrl + Down arrow jumps to the last row, Ctrl + Left arrow to the first column and Ctrl + Right arrow to the last. Ctrl + Home goes straight to A1.

Not working? Check this

  • Nothing happens: click into the sheet first, not into the formula bar or a search box.
  • The jump stops in the middle: there is an empty cell in the column. Press it again to jump to the next block.
  • The cursor moves only one cell: Ctrl was not held down. Hold Ctrl first, then press the arrow.
  • On a Mac use Command + Up arrow.

Quick answers

What is the shortcut to go to the top of the data in Excel?

Click a cell in the column and press Ctrl + Up arrow. To go to A1 press Ctrl + Home.

How do I select up to the top?

Hold Shift too: Ctrl + Shift + Up arrow selects from the active cell up to the first filled cell.

Why does it stop in the middle of my table?

It stops at the first empty cell. Press the shortcut again to jump to the next block of data.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games