Excel EXTEND SELECTION TO THE LAST CELL DOWN Keyboard Shortcut

Using the Extend Selection to the Last Cell Down Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

Use this Excel shortcut to extend the selection to the first non-empty cell below the active cell if the active cell is empty.
Discover 242 Excel Keyboard Shortcuts for Windows and Mac
Other useful Extending Selection keyboard shortcuts
Extend Selection to the Last Cell Up
Extend Selection by one Cell Left
Extend Selection by one Cell Up
Extend Selection by one Cell Down
Extend Selection to the Last Cell Right