Extend Selection to Last Cell in Worksheet

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