Add or Remove Fields from an Existing Pivot Table

November 21, 2022 - by Bill Jelen

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. Or - simply uncheck Region in the top of the Pivot Table Fields dialog.

To remove Region from a Pivot Table, drag the Region tile outside of the Pivot Table Fields pane. The mouse cursor changes to the word Region with an italics X icon. (The X means delete) — Figure 825. Remove a field.

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.

Drag region out of Rows and checkmark Customer. Your pivot table now shows Products across the top and Customers down the side. — Figure 826. Remove Region, add Customer.

This article is an excerpt from Power Excel With MrExcel

Title photo by David Aler on Unsplash