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.
- Select a cell in the pivot table.
- Choose Format
AutoFormat. ...
Get Excel Pivot Tables Recipe Book: A Problem-Solution Approach now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.