• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Advanced Formatting and Editi... > Ungrouping and Grouping Columns and ...

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint