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
4.1. Using PivotTable Styles: Applying a Predefined Format
You create several pivot ...