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'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'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 cover shortcuts you can use to select special cells with Go To Special
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 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.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.