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.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: How to quickly fill in missing data - part 2
How to quickly fill in missing data - part 2
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.