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


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


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

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

Get Excel Pivot Tables Recipe Book: A Problem-Solution Approach now with the O’Reilly learning platform.

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