Rename Excel PivotTable headings

Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.

By default, PivotTable provides custom name such as “Sum of Amounts” or Count of Numbers” etc when you add a field to the table. You may not be always happy to use these default custom names for your PivotTable, so feel free to modify the headings to something you like.

Click on the column heading cell to rename the heading.

Two ways to rename a PivotTable column heading

Type the heading name you want to give to the column header in the Formula Bar, just like we do for any other cell.

You can also change the ‘Custom Name’ in the Value Field Settings. Right-click on the column heading cell and navigate to Value Field Settings and type the new name for your column heading and press OK.

Want More?

Office Watch has the latest news and tips about Microsoft Office.  Delivered once a week.