Add or Remove Fields from an Existing Pivot Table


November 21, 2022 - by Bill Jelen

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. 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



Bill Jelen is the author / co-author of:
Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.