• Excel Book Excerpt

Excel Add or Remove Fields from an Existing Pivot Table

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Add or Remove Fields
from an Existing Pivot Table

Problem: I’ve seen how easy it is to rearrange an existing pivot table by swapping Region and Product fields. Now, what if I want to replace the Region field with the Customer field?

Strategy: In order to remove the Region field from a pivot table, you click on the Region button in the Row Labels drop zone of the PivotTable Field List dialog. Then you drag the button outside the Field List dialog. The cell pointer will change to include a black X, which is synonymous with Delete.

LE10000792.jpg 

Figure 763 Remove a field.

Alternatively, you can uncheck the Region field from the top of the Field List.

To add the Customer field to the Row Labels drop zone, you simply click the Customer check box in the top of the PivotTable Field List dialog. Because the field is a text field, it will automatically move to the Row Labels drop zone.

Results: The new field will be added to the pivot table.

LE10000793.jpg 

Figure 764 Remove Region, add Customer.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:



Popular Pages

More Info