Excel Pivot Tables Recipe Book: A Problem-Solution Approach

CHAPTER 4Formatting a Pivot Table

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. The solutions in this chapter are those that can be applied manually. Some formatting issues should be addressed by using macros, and are included in Chapter 13.

4.1. Using AutoFormat: Applying a Predefined Format

Problem

You'd like a quick way to format your pivot table.

Solution

You can use the AutoFormat command to apply a predefined format.

1. Select a cell in the pivot table.
2. Choose Format AutoFormat. ...