Home > Getting Started Guide > Creating a Simple Pivot Table in Excel > Pivot Tables Excel 2007 > Pivot Table Field List > 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.

Fields that appear in the Pivot Table will have a tick in their check box on the Field List. De-selecting this check box will remove the field from the Pivot Table.

Remove a Field

Method

1. From the Field List select the check box next to the field you wish to remove

OR

1. From the Field List, select the drop down arrow next to the field

2. Select Remove Field

Add a Field

Method

1. Select the check box next to the field in the Field List

OR

1. Select the Field in the Field List and drag it to the desired area e.g. Report Filter

Move Fields within the Table

Method

1. From the Field List, drag the field to the desired area

OR

1. From the Field List, select the drop down arrow next to the field

2. Select Move Up, Move down etc.