Extend Selection One Screen Down in Excel
This shortcut lets you extend the current selection downward by one full screen. It is especially useful when working with large worksheets where scrolling manually is inefficient.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + Page Down | Cmd + Shift + Fn + ↓ |
What Does This Shortcut Do?
Pressing this shortcut extends the selection downward by approximately one visible screen of rows while keeping the starting cell fixed.
How to Use the Shortcut
- Select a starting cell in the worksheet
- Hold Ctrl + Shift (Windows) or Cmd + Shift (Mac)
- Press Page Down
- The selection extends one screen downward
Tips & Best Practices
- Useful for selecting large ranges quickly
- Works regardless of blank cells
- Combine with Page Up for fast navigation
FAQ
- Q: How many rows does one screen include?
- It depends on zoom level, screen size, and row height.
- Q: Does this shortcut stop at blank rows?
- No, it moves strictly by screen length.
- Q: Can I use this shortcut in protected worksheets?
- Yes, selection works even if editing is restricted.