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