Extend Selection One Screen Up in Excel
This shortcut allows you to extend the current selection upward by one full screen. It is useful when working with large worksheets where scrolling manually would slow you down.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + Page Up | Cmd + Shift + Fn + ↑ |
What Does This Shortcut Do?
Pressing this shortcut extends the selection upward by approximately one visible screen of rows while keeping the active cell anchored.
How to Use the Shortcut
- Select a starting cell in your worksheet
- Hold Ctrl + Shift (Windows) or Cmd + Shift (Mac)
- Press Page Up
- The selection extends one screen upward
Tips & Best Practices
- Ideal for selecting large ranges quickly
- Works well with data analysis and formatting tasks
- Combine with Page Down to fine-tune selection
FAQ
- Q: How many rows does one screen include?
- The number depends on your screen resolution and zoom level.
- Q: Does this shortcut stop at blank cells?
- No, it moves strictly by screen length, not data boundaries.
- Q: Can I use this in protected sheets?
- Yes, selection still works, but editing may be restricted.