Extend Selection One Screen Left in Excel
This shortcut allows you to extend the current selection one full screen to the left without losing the existing selected cells. It is especially useful when working with wide worksheets containing many columns.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + Page Up | Control + Shift + Fn + ↑ |
What Does This Shortcut Do?
When you use this shortcut, Excel extends the selection horizontally to the left by one visible screen width. The active cell remains fixed while the selected range grows.
How to Use the Shortcut
- Select or click any cell in a wide worksheet
- Press and hold Ctrl + Shift (Windows) or Control + Shift (Mac)
- Press Page Up
- The selection extends one screen to the left
Tips & Best Practices
- Best for selecting large horizontal datasets
- Works well before copying, formatting, or deleting data
- Repeat the shortcut to extend across multiple screens
FAQ
- Q: Does this shortcut select until column A?
- No. It extends the selection only by one screen width at a time.
- Q: Can I combine it with vertical selection shortcuts?
- Yes. You can combine it with vertical extend shortcuts to select large data blocks.
- Q: Does this work in Excel Tables?
- Yes, but table boundaries may limit how far the selection extends.