Learn › Excel › Jump to the first column

Excel jump left shortcut: Ctrl + ←

Jump to the first filled cell on the left of your row 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 + Left arrow jumps from the active cell to the first filled cell of the row, the edge of your data on the left. You get back to the first column without scrolling.

When to use it

Use it after you went far to the right in a wide table. It stops at the first empty cell, so a gap in the row stops the jump early.

How to do it

  1. Click a cell at the end of a row.
  2. Press Ctrl + Left arrow (on a Mac: Command + Left arrow).
  3. You land in the first column. Press Ctrl + Right arrow to go back to the end.
Good to know: Add Shift to select while you jump: Ctrl + Shift + Left arrow selects from the active cell to the first filled cell.

A quick example

In a sales table with 12 columns, click J3 and press Ctrl + Left arrow: you land in A3, the first column.

Ctrl + Left arrow and the other jumps

Ctrl + Right arrow jumps to the last column, Ctrl + Up arrow to the top and Ctrl + Down arrow to the bottom. 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 row. 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 + Left arrow.

Quick answers

What is the shortcut to go to the first column in Excel?

Click a cell in the row and press Ctrl + Left arrow. You jump to the first filled cell of the row.

How do I select to the first column?

Hold Shift too: Ctrl + Shift + Left arrow selects from the active cell 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