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.

pivotfieldadd00

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

pivotfieldadd01

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.

pivottoolbarshowfieldlist

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

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

____________

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.