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