📊Excel Shortcut

Extend Selection to Previous Sheet

Detailed guide to use "Extend Selection to Previous Sheet" in Excel

Shortcut Keys

The highlighted keys show where to press. Press the required keys together.

Windows

Ctrl+Shift+PgUp
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Home
Del
End
PgUp
PgDn
↑
←
↓
→

Windows: Ctrl+Shift+PageUp

Mac

⌘+⇧+fn↑
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
⌃
⌘
⌥
⌥
⌘
Fn
⌃
↑
←
↓
→

Mac: Cmd+Shift+PageUp

Basic Info

Category
Navigation
Difficulty
★★★(Advanced)

How to Use

  1. 1Select the target cell/range if needed
  2. 2Press the highlighted keys shown above together
  3. 3Extend Selection to Previous Sheet is executed

Practice

Practice this shortcut and build reliable muscle memory.

Start Shortcut PracticeSee Practice ModesStart Function Practice

Usage Tip

Extend the sheet selection to the previous worksheet.

Related Shortcuts

Extend Selection to Next Sheet

Same category
Ctrl + Shift + PageDown

Select Current Region or Entire Sheet

Same category
Ctrl + A

Move to Edge of Data

Same category
Ctrl + Up

Select to Edge of Data

Same category
Ctrl + Shift + Up

Select Entire Column

Same category
Ctrl + Space

Select Entire Row

Same category
Shift + Space

Move to Next Sheet

Same category
Ctrl + PageDown

Move to Previous Sheet

Same category
Ctrl + PageUp

More In This Category

Go to A1

Ctrl + Home

Find

Ctrl + F

Select Current Region or Entire Sheet

Ctrl + A
View Full Shortcut List

FAQ

What is the shortcut for Extend Selection to Previous Sheet?

Windows: Ctrl+Shift+PageUp. Mac: Cmd+Shift+PageUp.

How do I use Extend Selection to Previous Sheet?

Use it when you want to move around a worksheet quickly and cut down on mouse travel.

What shortcuts should I practice after Extend Selection to Previous Sheet?

Practice sheet navigation, range selection, and jump-to next and you can move through common Excel work much faster.

Where can I practice Extend Selection to Previous Sheet?

Use the page button to start a focused drill right away. If you switch to full practice, you can review sheet navigation, range selection, and jump-to in the same flow.

← Back to ListExcelGym Home