Back to library
Microsoft Excel

Select current and next sheet

Selects the current sheet and the next sheet in the workbook, creating a group selection.

Ctrl + Shift + PgDn

When to use it

Use to select multiple adjacent sheets for group operations like printing, copying, or formatting.

Pro tip

Press repeatedly to extend selection to more sheets. Use Ctrl+Shift+PgUp to select current and previous sheet.

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