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

Tip: 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.
I've watched three of your videos this morning and while I would consider myself somewhat advanced, I thought the tutorials were helpful and extremely well done.
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course