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

Chapter 13. Analyzing Data with Lists > Working with a Subtotal's Outline Symbo...

Working with a Subtotal's Outline Symbols

When Excel creates a subtotal, it displays various outline symbols to the left of the worksheet. You can use these symbols to hide or show detail data in the subtotals. Outlines work by dividing your data into different levels that show different amounts of detail. The subtotaled data in Figure 13.24 has three levels:

  • Level 1— The list grand total, which appears at the bottom of the list. It can't be seen in Figure 13.24.

  • Level 2— The list subtotals.

  • Level 3— The entire list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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