Extend selection to the first cell in the worksheet
Master this Excel shortcut with our comprehensive guide
Extending the Selection Shortcuts
Ctrl + Shift + Home
⌘ + Shift + ↑ + ←
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + Home
Instructions
1. Select a cell
2. Hold Ctrl + Shift
3. Press Home to select from current cell to A1
2. Hold Ctrl + Shift
3. Press Home to select from current cell to A1
Keyboard Shortcut
⌘ + Shift + ↑ + ←
Instructions
1. Highlight cell
2. Hold Command + Shift
3. Press Up + Left Arrow to select to first worksheet cell
2. Hold Command + Shift
3. Press Up + Left Arrow to select to first worksheet cell
💡 Pro Tip: Quickly select everything above and to the left for large data edits.
Quick Actions
More Extending the Selection Shortcuts
Shift + →
Shift + ←
Shift + ↑