Show/Hide Field Headers in Excel Pivot Tables

Bryan

Free Practice Workbook

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.

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:

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:

If you like this Excel tip, please share it

X Facebook LinkedIn Copy Email Print Reddit

Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Excel Pivot Tables Tutorials

30+ Excel & Office Courses

$1 Trial for 30 days

Access for $1

Cancel Anytime

30 Days - Full Access

$1 Trial for 30 days!

Access for $1

Cancel Anytime

Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
Practice Workbooks
Certificates of Completion
5 Amazing Bonuses

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!

$1 Trial for 30 days!

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-introduction.svg" alt="Introduction" width="48" height="48" /> Introduction

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" width="48" height="48" /> Formulas

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formatting.svg" alt="Formatting" width="48" height="48" /> Formatting

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" width="48" height="48" /> Charts

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-printing.svg" alt="Printing" width="48" height="48" /> Printing

$1 Trial for 30 days!

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" width="48" height="48" /> Formulas

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-pivot-tables.svg" alt="Pivot Tables" width="48" height="48" /> Pivot Tables

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-macros-vba.svg" alt="Macros & VBA" width="48" height="48" /> Macros & VBA

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-data-analysis.svg" alt="Data & Analysis" width="48" height="48" /> Data & Analysis

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" width="48" height="48" /> Charts

$1 Trial for 30 days!

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" width="48" height="48" /> Formulas

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-pivot-tables.svg" alt="Pivot Tables" width="48" height="48" /> Pivot Tables

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-macros-vba.svg" alt="Macros & VBA" width="48" height="48" /> Macros & VBA

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-query.svg" alt="Power Query" width="48" height="48" /> Power Query

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-pivot.svg" alt="Power Pivot" width="48" height="48" /> Power Pivot

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-data-analysis.svg" alt="Data & Analysis" width="48" height="48" /> Data & Analysis

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" width="48" height="48" /> Charts

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-bi.svg" alt="Power BI" width="48" height="48" /> Power BI

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-dashboards.svg" alt="Excel Dashboards" width="48" height="48" /> Excel Dashboards

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-financial-modeling.svg" alt="Financial Modeling" width="48" height="48" /> Financial Modeling

$1 Trial for 30 days!

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-word.svg" alt="Word" width="48" height="48" /> Word

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-powerpoint.svg" alt="PowerPoint" width="48" height="48" /> PowerPoint

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-outlook.svg" alt="Outlook" width="48" height="48" /> Outlook

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-onenote.svg" alt="OneNote" width="48" height="48" /> OneNote

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-teams.svg" alt="Teams" width="48" height="48" /> Teams

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-access.svg" alt="Access" width="48" height="48" /> Access

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-sharepoint.svg" alt="SharePoint" width="48" height="48" /> SharePoint

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-project.svg" alt="Project" width="48" height="48" /> Project

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-visio.svg" alt="Visio" width="48" height="48" /> Visio

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-automated.svg" alt="Power Automate" width="48" height="48" /> Power Automate

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-powerapps.svg" alt="Power Apps" width="48" height="48" /> Power Apps

<img loading="lazy" src="https://www.myexcelonline.com/meo-staging/wp-content/themes/meo-theme/web/assets/img/menu/icon-forms.svg" alt="Forms" width="48" height="48" /> Forms

$1 Trial for 30 days!

101 Most Popular Excel Formulas

101 Most Popular Excel Formulas

101 Ways to Master Excel Pivot Tables

101 Ways to Master Excel Pivot Tables

101 Ready To Use Excel Macros

101 Ready To Use Excel Macros

Ultimate Debt Repayment Tracker

Ultimate personal finance tracker

Ultimate small Business Bookkeeping tracker

Show/Hide Field Headers in Excel Pivot Tables

Whenever you work with Pivot Tables, you can see the Row Labels and Column Labels that are automatically generated on top.

Bryan

Steps To Follow

30+ Excel & Office Courses

$1 Trial for 30 days

Related Articles

$1 Trial for 30 days!

Get Video Training

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

Introduction

Formulas

Formatting

Charts

Printing

Formulas

Pivot Tables

Macros & VBA

Data & Analysis

Charts

Formulas

Pivot Tables

Macros & VBA

Power Query

Power Pivot

Data & Analysis

Charts

Power BI

Excel Dashboards

Financial Modeling

Word

PowerPoint

Outlook

OneNote

Teams

Access

SharePoint

Project

Visio

Power Automate

Power Apps

Forms