Open Ungroup Dialog Box

Using the Open Ungroup Dialog Box Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut displays the Ungroup dialog box when whole rows or columns are not selected.
Other useful Grid Operation keyboard shortcuts