O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Formatting a PivotTable

To make a PivotTable look good and convey its contents effectively, you can format it. You can apply the formatting at any point, but usually it's best to lay out the framework and fields of the PivotTable first so that you have a fair idea of how it will appear.

Applying a PivotTable Style

As you've seen in the examples so far in this chapter, Excel applies a style to a PivotTable when you create it. The style helps you distinguish the different areas of the PivotTable visually.

To change the way a PivotTable looks, apply a different style to it from the PivotTable Styles group on the PivotTable tab of the Ribbon. You can either click one of the styles in the Quick Styles box or hold the mouse pointer over the Quick Styles ...

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