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.
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.
Now click Replace All at the bottom left corner.
You could see the word “Sum of” has been removed.
Hope this helped.
