Exceljet

Quick, clean, and to the point

Select current region around active cell

Windows shortcut

CtrlShift*

Mac shortcut

⇧⌃Space

This shortcut will extend the selection around the active cell to include the "current region" around the active cell. See Ctrl A, and ⌘ A for very similar behavior.

222 Excel Shortcuts for Windows and Mac

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Topics

Formula Basics
Formula Examples
Conditional Formatting
Pivot Tables
Excel Tables
Excel Charts
Shortcuts
More...

Key functions

IF function
VLOOKUP function
XLOOKUP function
SUMIFS function
COUNTIFS function
SUMPRODUCT function
INDEX and MATCH
More...

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

Thanks for this site. It really is quick and to the point. Each article gives the information you need to solve the problem without excessive descriptions that you usually have to skim through. Keep up the great work! -Pernilla

Select current region around active cell

Download 200+ Excel Shortcuts

Excel video training