Show/Hide Field Headers in Excel Pivot Tables | MyExcelOnline

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.

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 WORKBOOK


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

Show/Hide Field Headers in Excel Pivot Tables | MyExcelOnline

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

Click on it to hide the field headers:

Show/Hide Field Headers

And they are now hidden!

Show/Hide Field Headers in Excel Pivot Tables | MyExcelOnline

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

Show/Hide Field Headers

The headers will be visible again!

Show/Hide Field Headers in Excel Pivot Tables | MyExcelOnline

 

HELPFUL RESOURCE:

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

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn