O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

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

Editing PivotTables

Editing PivotTables

After you have created a PivotTable, you can edit it to control how your data is displayed. As an example, consider the following PivotTable.

Editing PivotTables

In this example, two fields require editing: Month and Weekday. Because all of the data in the list used to create the PivotTable is from the month of January, no information is imparted by including the Month field. The unused Weekday field, however, can be used to limit the data shown in the body of the PivotTable to sales occurring on one weekday, such as Wednesday.

Tip

Fields used in the ...

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