Ungroup Rows or Columns

Using the Ungroup Rows or Columns Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut ungroups selected rows or columns when whole rows or columns are selected.
Other useful Grid Operation keyboard shortcuts