Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Here is How You Can Edit a Pivot Table in Excel

We can edit a PivotTable by removing or adding columns, row, or modify the data when there are new entries. The steps below will walk through the process.

Figure 1- How to Edit a Pivot Table in Excel

Setting up the Data

  • We will use the Pivot Table in figure 2 to illustrate how we can edit a Pivot Table

Figure 2 – Setting up the Data

How to Add a Column to a Pivot Table

  • We will add a new column called Product. This is the product of sales and orders
  • We will click on the Pivot Table
  • We will click “Analyze”, and then, “Change Data Source



Figure 3- Clicking on Change Data Source

  • We will ensure that the range includes the new data

Figure 4- Change Pivot Table Data Source Dialog box

  • We will click OK. This immediately adds Product to the Pivot Table Fields
  • We will check the Product box in the Pivot Table Fields
  • We can use the same approach when we add rows. However, after adding the rows to the table, we will click on the Pivot Table, right-click, and click Refresh



Figure 5 – Adding a Column to the Pivot Table

How to Remove a Column from a Pivot Table

  • We can remove a column from a Pivot Table by unmarking the box in the Pivot Table Fields.
  • For instance, if we want to remove the Orders, we will click the box beside Orders to remove the orders column

Figure 6 – Removing a Column from the Pivot Table

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment


Subscribe to

Get updates on helpful Excel topics

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc