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

Chapter 9. Advanced Formatting and Editi... > Displaying a Specific Outline Level

Displaying a Specific Outline Level

To collapse each quarter so that only the quarterly totals and annual totals appear, you can click the hide detail symbols above Q1, Q2, Q3, and Q4. The level symbols—the squares with numerals at the upper left corner of the worksheet—provide an easier way, however. An outline usually has two sets of level symbols, one for columns and one for rows. The column level symbols appear above the worksheet, and the row level symbols appear to the left of the worksheet.

You can use the level symbols to set an entire worksheet to a specific level of detail. The outlined worksheet shown in Figure 9-30 has three levels each for both columns and rows. By clicking both of the number 2 level symbols in the upper left corner of the worksheet, you can transform the outline shown in Figure 9-30 to the one shown in Figure 9-31. By clicking the number 1 level symbols, you can further reduce the level of detail displayed by the worksheet so that only the grand total sales figure for the year in cell R16 is shown.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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