Back to library
Microsoft Excel

Move to the last cell of selected column

Moves the active cell to the last cell in the current column that contains data or formatting.

Ctrl +

When to use it

When you need to quickly jump to the bottom of a column of data.

Pro tip

If the column is empty, this shortcut moves to the last row of the worksheet.

Esc F1 F2 F3 F4
F5 F6 F7 F8
F9 F10 F11 F12
PrtSc Scroll Pause
` ~ 1 ! 2 @ 3 # 4 $ 5 % 6 ^ 7 & 8 * 9 ( 0 ) - _ = +
Ins Home PgUp
Tab Q W E R T Y U I O P [ { ] } \ |
Del End PgDn
Caps A S D F G H J K L ; : ' " Enter
Shift Z X C V B N M , < . > / ? Shift
Ctrl Win Alt Space Fn Alt Ctrl

More from Microsoft Excel View all