O'Reilly logo

2007 Microsoft® Office System Inside Out by Microsoft Corporation

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Choosing Report Layout Options

PivotTables in Excel 2007, by default, use a more compact presentation style than earlier versions used. This default layout (called Compact) indents inner fields on the row axis beneath their outer fields, letting you see more information at a glance. If you prefer, you can select from two alternative layouts, called Outline and Tabular. To switch from one layout to another, select a cell within the table, click the Design tab under PivotTable Tools, click Report Layout (in the Layout group), and then click one of the displayed layouts (Show In Compact Form, Show In Outline Form, or Show In Tabular Form). Figure 15-8 compares the three layout options.

Figure 15-8. Excel offers three PivotTable layout options: Compact ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required