Extend selection upwards to the last cell
Master this Excel shortcut with our comprehensive guide
Extending the Selection Shortcuts
Ctrl + Shift + ↑
⌘ + Shift + ↑
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + ↑
Instructions
1. Select starting cell
2. Hold Ctrl + Shift
3. Press Up Arrow to extend selection to the first filled cell above
2. Hold Ctrl + Shift
3. Press Up Arrow to extend selection to the first filled cell above
Keyboard Shortcut
⌘ + Shift + ↑
Instructions
1. Highlight starting cell
2. Hold Command + Shift
3. Press Up Arrow to select all filled cells above
2. Hold Command + Shift
3. Press Up Arrow to select all filled cells above
💡 Pro Tip: Quickly select large vertical ranges without dragging.
Quick Actions
More Extending the Selection Shortcuts
Shift + →
Shift + ←
Shift + ↑