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.

Thanks for the website - great resource and find emails of tips/hints really handy. -Jasmit
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