Using the Extend Selection to Last Cell in Worksheet Shortcut
Windows keyboard shortcut
Mac keyboard shortcut
Use this Excel shortcut to extend to the cell at the intersection of the last column on the right that contains data and the last row that contains data.
Other useful Extending Selection keyboard shortcuts