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
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
💡 Pro Tip: Use for bulk operations on large data sets efficiently.