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