Select all cells to the right 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 the starting cell
2. Hold Ctrl + Shift
3. Press Right Arrow to select all contiguous filled cells
Keyboard Shortcut
Option + Shift + →
Instructions
1. Select a starting cell
2. Hold Option + Shift
3. Press Right Arrow to select all filled cells to the right
💡 Pro Tip: Speeds up selecting data ranges for copying or formatting.
Previous Navigate the cursor to the lef...
Next Select all cells to the left w...
Quick Actions
All Shortcuts Excel Cell Editing Shortcuts Print All
More Excel Cell Editing Shortcuts
F2
Alt + ENTER
SHIFT + →