Show/Hide Field Headers in Excel Pivot Tables

But, Pivot Table being a tool for the presentation of data as well, you might want to hide these labels as well for making the data set more presentable. It is easy to Show/Hide Field Headers in a Pivot Table. Let us see how!

Exercise Workbook:

This is our pivot table. And you can see the 2 field headers on top:

STEP 1: Go to PivotTable Analyze > Show > Field Headers

Click on it to hide the field headers:

And they are now hidden!

You can click on the same button to show them again.

The headers will be visible again!

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.