Microsoft Office Tutorials and References
In Depth Information
Displaying a specific outline level
To collapse an outline level so that only the summary cells show, click that level’s hide detail
symbol. For example, if you no longer need to see the monthly sales in the outlined
worksheet (which is shown in Figure 8-72), click the hide detail symbols above columns E, I, and
M. The worksheet then looks like Figure 8-75.
Figure 8-75 When you click the hide detail symbols (–) above Q1, Q2, and Q3, Excel replaces
them with show detail symbols (+).
Show detail symbols with a plus sign on them now replace the hide detail symbols above
the Q1, Q2, and Q3 columns (columns E, I, and M). To redisplay the hidden details, click the
show detail symbols.
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 8-72 has three levels each for columns and for rows. By
clicking both of the level symbols labeled 2 in the upper-left corner of the worksheet, you
can transform the outline shown in Figure 8-72 to the one shown in Figure 8-73.
Search JabSto ::




Custom Search