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.

I also wanted to tell you in researching this formula problem, I combed through about 50 videos and websites. Yours was the most professional, easy to understand, and welcoming to a student who wishes to become more knowledgeable with Excel. -Devorah

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