Excel 2007 PivotTables Recipes: A Problem-Solution Approach

CHAPTER 4Formatting a Pivot Table

New formatting features were introduced for pivot tables in Excel 2007, including PivotTable Styles, Document Themes, Conditional Formatting, and Report Layouts, which add many exciting options for enhancing the look of your pivot tables. Questions about these new features are addressed in this chapter. Common problems with pivot table formatting include loss of formatting when the pivot table is changed or refreshed, showing or hiding subtotals and grand totals, and retaining formats applied in the source data.

Unless otherwise noted, the problems in this chapter are based on data in the sample file named Regions.xlsx.

4.1. Using PivotTable Styles: Applying a Predefined Format

Problem

You create several pivot ...