Excel 2010 Bible

Part IV: Using Advanced Excel Features

582

FIGURE 26.1

A simple sales summary with subtotals.

FIGURE 26.2

The worksheet after creating an outline.

Figure 26.3 depicts the outline after clicking the 2 button, which displays the second level of

details. Now, the outline shows only the totals for the regions (the detail rows are hidden). You can

partially expand the outline to show the detail for a particular region by clicking one of the + but-

tons. Collapsing the outline to level 1 shows only the headers and the Grand Total row.

Excel can create outlines in both directions. In the preceding examples, the outline is a row (verti-

cal) outline. Figure 26.4 shows the same model after a column (horizontal) outline was added.

Now, Excel also displays outline controls at the top.