Rename Excel PivotTable headings

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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.

img 5a009db2c3d40 - Rename Excel PivotTable headings

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.

img 5a009d4fb3be3 - Rename Excel PivotTable headings

subs profile e1563205311409 - Rename Excel PivotTable headings
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address