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

Comments welcome! Read this before posting a question.

I love your website and have learned a lot from this site. Most of your formula are elegant and beautiful and your explanations are easy to understand. Thank you for making learning EXCEL interesting. -Paul

Select current region around active cell

Download 200+ Excel Shortcuts

Excel video training