How to Modify the Fields in a Pivot Table in Excel 2007

To modify the fields used in your pivot table, first you display the Field list by following these steps:

1) Click any of the pivot table's cells.
Excel adds the PivotTable Tools contextual tab with the Options and Design tabs to the Ribbon.

2) Click the Options tab under the PivotTable Tools Contextual tab to display its buttons on the Ribbon.

3) Click the Field List button in Show/Hide group.
Excel displays the Pivot Table Field List task pane, showing the fields that are currently used in the pivot table as well as to which areas they’re currently assigned.

After displaying the Field List task pane, you can make any of the following modifications to the table's fields:

To remove a field, drag its field name out of any of its drop zones (Report Filter, Column Labels, Row Labels, and Values) and, when the mouse pointer changes to an x, release the mouse button or click its check box in the Choose Fields to Add list to remove its check mark.

To move an existing field to a new place in the table, drag its field name from its current drop zone to a new zone (Report Filter, Column Labels, Row Labels, or Values) at the bottom of the task pane.

To add a field to the table, drag its field name from the Choose Fields to Add list and drop the field in the desired drop zone (Report Filter, Column Labels, Row Labels, or Values) - note that all you want to do is add a field to the pivot table as an additional Row Labels field, you can also do this by simply clicking the field’s check box in Choose Fields to Add list to add a check mark.

Tags: pivot,pivot chart,pivot table,cell

Related Articles