Exceljet

Quick, clean, and to the point

Select current region

Windows shortcut 
CtrlA
Mac shortcut 
A

The first time you use this shortcut, Excel will select the current region around the active cell, if one can be detected, otherwise the whole sheet is selected. The second time you use the shortcut (consecutively), Excel will select the entire worksheet.

Related videos

Tip: How to quickly fill in missing data
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
Love your tutorials, they've been awesome in helping me learn all that Excel can do.
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course