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

  • Find Trailing Space In Excel

    There are situation when we try to look up some value in excel but we do not get the desired […]

    Share The Knowledge
  • Calculate Weighted Average In Excel

    Let’s see how to calculate a weighted average in excel. Weighted average is an average in which each quantity to […]

    Share The Knowledge
  • Strikethrough/Cut Text In Excel

    This post demonstrates how to strikethrough or cut the text in excel.To signify some change in the pre written text […]

    Share The Knowledge
  • Count Number Of Users Who Are Active In An Excel Workbook

    count number of active users in a workbook, vba to count no of users of a workbook, get active users count in excel, find user counts of a shared workbook in excel, get total number of users of a shared workbook in excel

    Share The Knowledge

Leave a Reply