Remove Sum Of From Pivot Table In Excel

In pivot  when we aggregate sum values we get a little prefix “Sum of” in the column name which sometimes is undesirable and does not look presentable.

Let’s see how to get rid of “Sum of” in pivot table field names in excel.

By default pivot table prefixes the column name with the string “Sum of” while calculating some values in the pivot table as shown below.

Capture

We will see how to remove these by simply using a find and replace tool.

Select the headers in the pivot table and press Ctrl+H to get the Find and Replace tool and Replace “Sum of” with anything (don’t type anything in Replace box) as shown below.




Capture

Now click Replace All at the bottom left corner.

You could see the word “Sum of” has been removed.

Capture

Hope this helped.

Share The Knowledge

Random Posts

  • Create Drop Down List In A Cell In Excel

    This post demonstrate how to create a drop down list in a cell which will enable the user to select […]

    Share The Knowledge
  • Color Alternate Rows In Excel

    Let’s see how we can color each alternate rows in excel. We could use the MOD and ROW function in […]

    Share The Knowledge
  • Filter By Bold Text In Excel

    This post demonstrates how we could filter data by bold font in excel, people sometime comments in bold to make […]

    Share The Knowledge
  • Count Number Of Braces/<> In Excel

    The post demonstrated how we could count number of braces “<>” in Excel. I have personally seen people HTML developers […]

    Share The Knowledge

Leave a Reply