Chapter 8. SETTING PIVOTTABLE OPTIONS

Apply a PivotTable Quick Style

In Chapter 6, 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 apply a Quick Style instead.

A Quick Style is a collection of formatting options ...

Get Excel® PivotTables and PivotCharts: Your visual blueprint™ for creatingdynamic spreadsheets, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.