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.
Download 200+ Excel Shortcuts
Such a great resource! Really appreciate your help - Carole
