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 ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
