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 using the OFFSET function; the most common way to create a dynamic named range with a formula.
In this lesson, we cover shortcuts you can use to select cells.
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.
In this video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions.
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.

Download 200+ Excel Shortcuts

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