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

Comments welcome! Read this before posting a question.

Excellent - Excellent - Excellent. You have such awesome tricks using Excel. I use them as a tool when I am teaching Excel to my students at a college where I teach. -Mike

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables