What is the shortcut for Select to Edge of Data?
Windows: Ctrl+Shift+Up. Mac: Ctrl+Shift+Up.
📊Excel Shortcut
Select to Edge of Data
Detailed guide to use "Select to Edge of Data" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Ctrl
⇧
Up
Windows shortcut: Ctrl+Shift+Up
Mac
Ctrl
⇧
Up
Mac shortcut: Ctrl+Shift+Up
In Action
This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.
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
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Select to Edge of Data is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Extend the selection to the edge of a contiguous range.
Related Shortcuts
Move to Edge of Data
Ctrl + 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
Extend Selection to Last Used Cell
Ctrl + Shift + End
Select Current Region or Entire Sheet
Ctrl + A
Select Entire Column
Ctrl + Space
More In This Category
FAQ
How do I use Select to Edge of Data?
Use it when you want to move around a worksheet quickly and cut down on mouse travel.
What shortcuts should I practice after Select to Edge of Data?
Practice sheet navigation, range selection, and jump-to next and you can move through common Excel work much faster.
Where can I practice Select to Edge of Data?
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 Select to Edge of Data?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.