Free Practice WorkbookWhenever you work with Pivot Tables, you can see the Row Labels and Column Labels that are automatically generated on top. These can easily be used to filter out your records. But sometimes, you may need ot hide them to make the data set more presentable. In this article, you will learn how to show/hide field headers in Excel Pivot Table.
Key Takeaways
- Field headers allow you to filter and sort data in a Pivot Table.
- You can show or hide field headers with a single click.
- Hiding field headers creates a cleaner-looking report.
- Showing field headers makes it easier to work with the Pivot Table.
- Hiding field headers does not affect your data or calculations.
Table of Contents
Introduction to Pivot Table
What is a Pivot table?
A pivot table in Excel is a tool that can summarize large amounts of data. This can be done without writing complex formulas. It can turn messy data into a clean summary within seconds.
A pivot table has 4 key areas:
- Rows
- Columns
- Values
- Filters
What are Field Headers?
Field headers are labels and drop-down buttons that appear above the rows and columns of the Pivot Table. They allow you to filter, sort, and rearrange the data directly within the PivotTable.
How to 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:
And they are now hidden!
You can click on the same button to show them again.
The headers will be visible again!
When Should You Hide or Show Field Headers?
Hide Field Headers When:
- Creating dashboards or reports for printing.
- Presenting Pivot Tables during meetings.
- You want a clean, distraction-free layout.
- The report is finished and no further filtering is needed.
Show Field Headers When:
- Filtering or sorting Pivot Table data.
- Rearranging fields during analysis.
- Troubleshooting or editing the Pivot Table.
- Allowing others to interact with the report.
Frequently Asked Questions
How do I show or hide field headers in an Excel Pivot Table?
To show or hide field headers, select your Pivot Table, go to the PivotTable Analyze tab (or Options tab in older versions), and click Field Headers in the Show group. Clicking this option will toggle the field headers on or off.
Why would I want to hide field headers in a Pivot Table?
Hiding field headers helps create a cleaner, more professional-looking report by removing unnecessary elements, making it easier to present data in dashboards or reports without distractions.
Can I still modify my Pivot Table layout if I hide field headers?
No, if field headers are hidden, you won’t be able to drag and drop fields within the Pivot Table layout. To modify the layout, you need to re-enable field headers.
Will hiding field headers affect my Pivot Table data or calculations?
No, hiding field headers only changes the display; it does not remove data, affect calculations, or modify the structure of your Pivot Table.
Is there a shortcut to toggle field headers in Excel?
There is no direct keyboard shortcut, but you can quickly toggle field headers by selecting the Pivot Table and pressing Alt + J, T, H in Excel (for newer versions).
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.
30 Days - Full Access 
