Using the Extend Selection to the Last Cell Up Shortcut
Windows keyboard shortcut
Mac keyboard shortcut
Use this Excel shortcut to extend the selection to the first non-empty cell above the active cell if the active cell is empty.
Other useful Extending Selection keyboard shortcuts