Extend Selection to the Last Cell Down

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.
Other useful Extending Selection keyboard shortcuts