Excel EXTEND SELECTION TO THE LAST CELL UP Keyboard Shortcut

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