Quick, clean, and to the point

Select current region

Windows shortcut 
Mac shortcut 

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 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 video, we'll use MATCH to find the position of an item in a table, and the INDEX function to retrieve the value at that position in a two-way lookup.
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 video, we'll look at a way to quickly add missing data to a worksheet. It's a simple technique using a very basic formula, and a cool example of relative cell references.
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.