Extend selection down one screen
Windows shortcut
ShiftPgDn
Mac shortcut
Fn⇧↓
The distance moved down depends on the size of the worksheet window.
Related videos
The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to extend selections.
In this video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.