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.
- Select a cell in the pivot table.
- Choose Format AutoFormat. ...