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.
Discover 242 Excel Keyboard Shortcuts for Windows and Mac
Other useful Extending Selection keyboard shortcuts
Extend Selection to the Last Cell Up
Extend Selection to First Cell in Worksheet
Extend Selection Down One Screen
Extend Selection Right One Screen
Extend Selection to the Last Cell Right