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 video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions.
In this lesson, we cover shortcuts you can use to extend selections.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.