849
Editing and Updating a PivotTable
3. To use a tabular layout, select the Show Items in
Tabular Form option. To use an outline-style layout,
select the Show Items in Outline Form option.
4. Adjust any other options—to add a blank line or a
page break after each group, for example—and
click OK.
To make the tabular view in Figure 30.11 easier to read, a
hidden option was used. Right-click anywhere on the table,
choose Table Options, and then check the Merge Layout
option. The effect is to merge all cells for the outside row and column labels.
30
Figure 30.13
Removing Blank Cells and Error Messages
Because PivotTables automatically summarize all data, it’ ...