Excel 2010 Bible

Chapter 26: Creating and Using Worksheet Outlines

583

FIGURE 26.3

The worksheet after collapsing the outline to the second level.

FIGURE 26.4

The worksheet after adding a column outline.

If you create both a row and a column outline in a worksheet, you can work with each outline

independent of the other. For example, you can show the row outline at the second level and the

column outline at the first level. Figure 26.5 shows the model with both outlines collapsed at the

second level. The result is a nice high-level summary table that gives regional totals by quarter.

FIGURE 26.5

The worksheet with both outlines collapsed at the second level.