Exceljet

Quick, clean, and to the point

Open Ungroup Dialog Box

Windows shortcut

AltShift←

Mac shortcut

⌘⇧J

This shortcut will display the Ungroup Dialog Box as long as no whole rows or columns are selected.

222 Excel Shortcuts for Windows and Mac

Download 200+ Excel Shortcuts

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

Topics

Key functions

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.

This is just a short note to applaud the work you do. I am an accomplished excel user and mentor. I am also quickly elevating my Power BI skill set. I am a PhD engineer with two MBA's. You make it so easy for a novice to search for a problem type and a matching solution path with detailed explanation. -Dennis

Exceljet

Quick, clean, and to the point

Open Ungroup Dialog Box

Related videos

Download 200+ Excel Shortcuts

Excel video training