Back to library
Microsoft Excel

Select cells from current location to first cell of column

Extends the selection from the current cell to the first cell in the same column.

Shift + PgUp

When to use it

Use to quickly select a range from the active cell up to the top of the column.

Pro tip

Combine with Shift+PgDn to select down to the last cell of the column.

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