Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets

Chapter 6. Setting PivotTable Options

Apply an AutoFormat

In the Chapter 5 task "Format a PivotTable Cell," you learned how to apply formatting options such as alignments and fonts to portions of a PivotTable. This works well, particularly if you have custom formatting needs. For example, you may have in-house style guidelines that you need to follow. Unfortunately, applying formatting can be time-consuming, particularly if you are applying a number of different formatting options. And the total formatting time can become onerous if you need to apply different formatting options to different parts of the PivotTable. You can greatly reduce the time you spend formatting your PivotTables if you instead apply an AutoFormat.

An AutoFormat is a collection ...