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.