What is the shortcut for Extend Selection to Last Used Cell?
Windows: Ctrl+Shift+End. Mac: Fn+Shift+Right.
📊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
⇧
End
Windows shortcut: Ctrl+Shift+End
Mac
Fn
⇧
Right
Mac shortcut: Fn+Shift+Right
Basic Info
- Category
- Navigation
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Extend Selection to Last Used Cell is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Extend the selection to the bottom-right of the used range.
Related Shortcuts
Move to Edge of Data
Ctrl + Up
Select to Edge of Data
Ctrl + Shift + Up
Extend Selection to Next Sheet
Ctrl + Shift + PageDown
Extend Selection to Previous Sheet
Ctrl + Shift + PageUp
Replace
Ctrl + H
Extend Selection to A1
Ctrl + Shift + Home
Select Current Region or Entire Sheet
Ctrl + A
Select Entire Column
Ctrl + Space
More In This Category
FAQ
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.