• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Using PivotTables and PivotC... > Editing and Updating a PivotTable

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint