Extend selection to the right 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 starting cell
2. Hold Ctrl + Shift
3. Press Right Arrow to select all contiguous cells with values
2. Hold Ctrl + Shift
3. Press Right Arrow to select all contiguous cells with values
Keyboard Shortcut
⌘ + Shift + →
Instructions
1. Select a starting cell
2. Hold Command + Shift
3. Press Right Arrow to select till last filled cell
2. Hold Command + Shift
3. Press Right Arrow to select till last filled cell
💡 Pro Tip: Efficient for selecting large horizontal ranges.
Quick Actions
More Extending the Selection Shortcuts
Shift + →
Shift + ←
Shift + ↑