Extend selection to the left till 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 a cell
2. Hold Ctrl + Shift
3. Press Left Arrow to select contiguous filled cells to the left
2. Hold Ctrl + Shift
3. Press Left Arrow to select contiguous filled cells to the left
Keyboard Shortcut
⌘ + Shift + ←
Instructions
1. Select starting cell
2. Hold Command + Shift
3. Press Left Arrow to select till last filled cell leftwards
2. Hold Command + Shift
3. Press Left Arrow to select till last filled cell leftwards
💡 Pro Tip: Quickly highlight ranges for editing formulas or formatting.
Quick Actions
More Extending the Selection Shortcuts
Shift + →
Shift + ←
Shift + ↑