Exceljet

Quick, clean, and to the point

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.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas