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

Just a quick note to let you know the hard work you've clearly put into your website is soooo valuable to folks like myself. This has very quickly become my favorite excel site! So clean, so devoid of excel-snobs arguing over best practices like so many forums, and so robust in the amount of topics you guys cover. Thank you!

Select current region around active cell

Download 200+ Excel Shortcuts

Excel video training