Extend Selection to the Last Cell Left

Using the Extend Selection to the Last Cell Left Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

Use this Excel shortcut to extend the selection to the first non-empty cell to the left if the active cell is empty.
Other useful Extending Selection keyboard shortcuts