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.