O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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 and Updating a PivotTable

After you create a PivotTable, it's easy to rearrange fields and data items. Drag fields from one place to another to change the display of data—from a row field to a column field, for example, if you want to see values side by side rather than one above the other. Right-click to display shortcut menus that let you adjust formatting and other options for each field. This section describes common procedures for editing PivotTables.

If you've upgraded from Excel 2000, you should notice a significant change in the arrangement of PivotTable editing tools. The assortment of menu options on the PivotTable toolbar is expanded, and the PivotTable Field List is now a separate control, as shown in Figure 27.7.

Figure ...

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