Extend selection to the last cell in the worksheet
Master this Excel shortcut with our comprehensive guide
Extending the Selection Shortcuts
Ctrl + Shift + End
⌘ + Shift + ↓ + →
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + End
Instructions
1. Select a cell
2. Hold Ctrl + Shift
3. Press End to select from current cell to last filled cell
2. Hold Ctrl + Shift
3. Press End to select from current cell to last filled cell
Keyboard Shortcut
⌘ + Shift + ↓ + →
Instructions
1. Highlight starting cell
2. Hold Command + Shift
3. Press Down + Right Arrow to select all cells to the last used cell
2. Hold Command + Shift
3. Press Down + Right Arrow to select all cells to the last used cell
💡 Pro Tip: Use for bulk operations on large data sets efficiently.
Quick Actions
More Extending the Selection Shortcuts
Shift + →
Shift + ←
Shift + ↑