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 introduce the idea of a dynamic range and show you why you might want to use one. Spoiler: they adjust formulas automatically when data changes.
In this video, we'll look at how to several ways calculate the number of days between dates. To get started, let's first first set up some dates, so we have a visual representation to refer to.
In this lesson, we cover shortcuts you can use to select special cells with Go To Special
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.
In this lesson, we cover shortcuts you can use to select special cells with Go To Special