O'Reilly logo

Pivot Table Data Crunching by Michael Alexander, Bill Jelen

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

4. Formatting Your Pivot Table Report

In this Chapter

Using AutoFormat 55

Applying Your Own Style 58

Setting Table Options 61

Using AutoFormat

Although it may sound a bit trivial, formatting can be an important aspect of creating a pivot table report. Pivot tables make it very easy to produce reports that summarize data by three, four, five, or more fields. When you start to show this many fields on a two-dimensional piece of paper, the totals can get very busy. Besides giving your pivot table reports a professional look and feel, formatting can have an illuminating effect on reports that are convoluted by large amounts of data. The right formatting can make your pivot table reports easier to read and improve the clarity of your data.

One of ...

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