Dragging Fields from the Pivot Table Toolbar


Use the Pivot Table toolbar and the Pivot Table template to add your first fields to your Pivot Table.  A Pivot Table must have at least two fields: a data field and at least one of the following fields page, row or column.

 

Starting Point:  You have completed all of the Pivot Wizard dialog boxes.  A new worksheet has been added to your workbook and both the Pivot Table template and toolbar are displayed.

 

  1. From the Pivot Table toolbar, click and drag a field to at least one of the following template areas:

  2. From the Pivot Table toolbar, click and drag a field to Drop Data Items Here area.

Note:  You can drag multiple fields to any area of the Pivot Table template.