Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
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’ ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link