O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required