Extend Selection One Screen Right in Excel
This shortcut allows you to extend the current selection horizontally by one full screen to the right. It is useful when working with wide datasets that span many columns.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + → | Cmd + Shift + → |
What Does This Shortcut Do?
When you use this shortcut, Excel extends the selection one visible screen to the right while keeping the starting cell fixed.
How to Use the Shortcut
- Select a starting cell or range
- Hold Ctrl + Shift (Windows) or Cmd + Shift (Mac)
- Press the Right Arrow key
- The selection expands one screen to the right
Tips & Best Practices
- Ideal for selecting wide tables quickly
- Does not stop at blank columns
- Combine with screen-left shortcut for precise control
FAQ
- Q: How many columns are selected in one screen?
- It depends on zoom level, column width, and screen resolution.
- Q: Does this work in Excel tables?
- Yes, it works in normal ranges and structured tables.
- Q: Can I repeat the shortcut multiple times?
- Yes, each press extends the selection by another screen.