Quick, clean, and to the point

Open Ungroup Dialog Box

Windows shortcut 
Mac shortcut 

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