Ungrouping and Grouping Columns and Rows

If the default automatic outline doesn't give you the structure you expect, you can adjust it by ungrouping or grouping particular columns or rows. You can easily change the hierarchy of outlined columns and rows by choosing Data, Group And Outline. Select the columns or rows you want to change and choose one of the options.

For example, you could select row 8 in the outlined worksheet shown in Figure 9-30 and choose Ungroup to change row 8 from level 2 to level 1. The outlining symbol to the left of the row moves to the left under the row level 1 button. To restore the row to its proper level, choose Group.