Pinterest Pixel

Show/Hide Field Headers in Excel Pivot Tables

Bryan
Whenever you work with Pivot Tables, you can see the Row Labels and Column Labels that are automatically generated on top.
This is handy as they can be used to filter out your records.
Show/Hide Field Headers in Excel Pivot Tables | MyExcelOnline Show/Hide Field Headers in Excel Pivot Tables | MyExcelOnline

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:

download excel workbookShow-or-Hide-Field-Headers.xlsx


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

Show/Hide Field Headers in Excel Pivot Tables

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

Click on it to hide the field headers:

Show/Hide Field Headers in Excel Pivot Tables

And they are now hidden!

Show/Hide Field Headers in Excel Pivot Tables

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

Show/Hide Field Headers in Excel Pivot Tables

The headers will be visible again!

Show/Hide Field Headers in Excel Pivot Tables

 

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

If you like this Excel tip, please share it
Show/Hide Field Headers in Excel Pivot Tables | MyExcelOnline
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.

See also  Format Error Values in a Pivot Table

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...