Beginning Pivot Tables in Excel 2007

CHAPTER 5Formatting a Pivot Table

In this chapter, you'll continue to work with the WorkOrders pivot table. First, download and open the sample file WorkOrders_02.xlsx. You'll add formatting to the pivot table to enhance the data presentation. With suitable formatting, you can make the pivot table easier to read, and you can highlight specific data. You'll also apply, modify, and create pivot table styles and themes in order to make formatting consistent throughout your workbook.

Controlling the Report Layout

First you'll experiment with the overall layout options for the pivot table. Three layouts are available for pivot tables: Compact Form, Outline Form, and Tabular Form. When you create a new pivot table, it is automatically formatted with ...