Exceljet

Quick, clean, and to the point

Extend selection to last cell in worksheet

Windows shortcut 
CtrlShiftEnd
Mac shortcut 
Fn

Extends the selection to the cell at the intersection of the last column (to the right) that contains data and the last row that contains data. The last cell in a worksheet may or may not contain data.

This is the best Excel training site I have ever seen. -Kedy
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course