Back to library
Microsoft Excel

Move to last cell in worksheet

Move the active cell to the last cell on the worksheet, which is the intersection of the lowest used row and the rightmost used column.

Ctrl + End

When to use it

When you need to quickly navigate to the end of your data range in a worksheet.

Pro tip

If the worksheet is empty, Ctrl+End moves to the last cell of the grid (typically column XFD, row 1048576).

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