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
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.
