Learn › Excel › Jump to the last column

Excel jump right shortcut: Ctrl + →

Jump to the last filled cell on the right 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 + Right arrow jumps from the active cell to the last filled cell of the row, the edge of your data on the right. You reach the last column without scrolling.

When to use it

Use it in a table with many columns, to see the last column at once. It stops at the first empty cell, so a gap in the row stops the jump early.

How to do it

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

A quick example

In a sales table with 12 columns, click A5 and press Ctrl + Right arrow: you land in L5, the last column of the row.

Ctrl + Right arrow and the other jumps

Ctrl + Left arrow jumps to the first column, Ctrl + Up arrow to the top and Ctrl + Down arrow to the bottom. Ctrl + End goes to the very last cell of the data.

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 + Right arrow.

Quick answers

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

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

How do I select to the last column?

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