O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel 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

Chapter 11. Formatting Pivot Tables

In this chapter

The New Compact View 216

Report Layout Options 220

Special Considerations When Adding Data Fields to the Value Section 224

Formatting a Pivot Table 227

As shown in Chapter 10, pivot tables are very fast at creating summary reports from thousands of rows of data. Once you’ve developed the summary information, you might need to spend some time improving the format of the pivot table. Excel 2007 offers some exciting new options in pivot table formatting. Unfortunately, Excel 2007 still offers some annoying problems that have plagued pivot table fans for a decade.

The New Compact View

In the pivot table shown in Figure 11.1, Column A contains three different fields: Region, Product, and Customer. ...

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