Home > Getting Started Guide > Creating a Simple Pivot Table in Excel > Pivot Tables Excel 2003 > Remove, Add and Move fields

Remove, Add and Move fields

When selecting a field from the data area to move or remove, you need to select the field by placing the mouse pointer on the border of the field and clicking when the pointer changes to the normal arrow pointer.

 

Remove a Field

Method

1. Select a Field and drag it outside of the Pivot Table area and drop it

OR

1. Right click on a Field

2. Select Hide

 

Add a Field

Method

1. Select a Field from the Field List

2. Drag it into the Pivot Table area and drop it in the appropriate position

OR

1. On the Pivot Table toolbar select Pivot Table

2. Pivot Table Wizard, select the Layout button

3. Drag the fields to the appropriate position

OR

1. Select the Field in the Field List

2. From the drop down, select the Area you would like to add it to