Ungroup

To remove grouping for certain rows without deleting the whole outline, do the following:Select the rows you want to ungroup.Go to the Data tab > O...

Shift+Alt+Left Arrow is the shortcut to ungroup. Again, the trick here is to select the entire rows or columns you want to group/ungroup first. Otherw...