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

Related videos

The videos below demonstrate this shortcut.

Shortcuts to group, ungroup, and outline

In this lesson, we cover shortcuts you can use to group and outline data.

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Thanks for the information you provide. It has already saved me hours. It also makes excel sort of fun (gasp). -Martin

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