📊Excel Shortcut

Extend Selection to Last Used Cell

Detailed guide to use "Extend Selection to Last Used Cell" in Excel

Shortcut Keys

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

Windows

Ctrl+Shift+End
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+End

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: Fn+Shift+Right

In Action

This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.

Windows Excel example (US key symbols). For Mac or other keyboard layouts, see the keys at the top of the page. Number formats may vary by region.

Auto-playing example
Active: B2Selection: B2Sheet: Sheet1Step 1/2

You can scroll the sheet horizontally

↶↷BIUGeneral
Name Box
B2
Formula Bar
fx12
◢
A
B
C
D
E
F
1
Item
Qty
Price
Total
Owner
Note
2
Pen
12
80
960
Aki
Rush
3
Pad
6
120
720
Mina
Review
4
File
4
300
1200
Ken
Done
5
Box
3
450
1350
Sora
Hold
6
Memo
Ready
2026-03-28
Sheet1
Ready100%

Basic Info

Category
Navigation
Difficulty
★★☆(Intermediate)

How to Use

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

Practice

Practice this shortcut and build reliable muscle memory.

Start Shortcut PracticeSee Practice ModesStart Function Practice

Usage Tip

Extend the selection to the bottom-right of the used range.

Related Shortcuts

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

Go To

Same category
F5

Replace

Same category
Ctrl + H

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 Last Used Cell?

Windows: Ctrl+Shift+End. Mac: Fn+Shift+Right.

How do I use Extend Selection to Last Used Cell?

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 Last Used Cell?

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 Last Used Cell?

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.

What is the action preview for Extend Selection to Last Used Cell?

A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.

← Back to ListExcelGym Home