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

The videos below demonstrate this shortcut.
In this video, we'll look at how to create a dynamic named range with the INDEX function. INDEX is a non-volatile function, so it won't recalculate whenever a change is made to a worksheet.
In this video, we compare formulas and pivot tables side-by-side to build the same reports to demonstrate how powerful and easy to use pivot tables are.
In this lesson, we cover shortcuts you can use to select cells.
In this video, we'll look at how to create a dynamic named range using the OFFSET function, the most common way to create dynamic names range with a formula.
In this lesson, we cover shortcuts you can use to select special cells with Go To Special