Select all cells to the left with values
Master this Excel shortcut with our comprehensive guide
Excel Cell Editing Shortcuts
Ctrl + SHIFT + ←
Option + Shift + ←
How to Use This Shortcut
Keyboard Shortcut
Ctrl + SHIFT + ←
Instructions
1. Select starting cell
2. Hold Ctrl + Shift
3. Press Left Arrow to select contiguous filled cells
2. Hold Ctrl + Shift
3. Press Left Arrow to select contiguous filled cells
Keyboard Shortcut
Option + Shift + ←
Instructions
1. Select a starting cell
2. Hold Option + Shift
3. Press Left Arrow to select filled cells to the left
2. Hold Option + Shift
3. Press Left Arrow to select filled cells to the left
💡 Pro Tip: Useful for selecting rows quickly for edits or formatting.
Quick Actions
More Excel Cell Editing Shortcuts
Alt + ENTER
SHIFT + →