Quickly Add Fields in Excel 2003 Pivot Table

When you have a long list of fields in an Excel 2003 pivot table, it can take a long time to drag them into the pivot table layout, using the PivotTable Wizard.

For a quicker way to add the fields, don’t go into the Layout screen in Step 3 — just click the Finish button.

Add Fields from the PivotTable Field List

When the PivotTable Wizard closes, you’ll see a blank pivot table on the worksheet.

Note: If the PivotTable Field List isn’t visible, click the Show Field List button on the PivotTable Toolbar.

To add the pivot fields:

1. Then, in the Field List, select one of the layout areas from the drop down list.
   • 
2. In the Field List, double-click on each field that you want to add to the selected layout area.
   • 

Repeat Steps 1 and 2, for all the layout areas, leaving the Data Area to fill in last.

____________