Quick, clean, and to the point

Extend selection down one screen

Windows shortcut 
Mac shortcut 

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.