Pinterest Pixel

Show & Hide Field List in Excel Pivot Table

Have you ever had the scenario where you are working on your Pivot Table and the Field... read more

Download Excel Workbook
Bryan
Posted on

Overview

Have you ever had the scenario where you are working on your Pivot Table and the Field List disappears?

Lots of Excel users get annoyed with this but luckily I’m here to help you out and explain to you How to Show Pivot Table Fields 🙂

There are several methods to show & hide Pivot Table Field List:

Let’s look at each method one-by-one!

 

Using Right Click

If your Pivot Table Field List disappears, you can easily bring it back as I show you below!

For our example, this is our Pivot Table:

Show & Hide Field List in Excel Pivot Table

 

Watch it on YouTube and give it a thumbs-up!

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

Follow the step-by-step tutorial on How to Show Pivot Table Fields and download this Excel workbook to practice along:

download excel workbookShow-Hide-Field-List.xlsx

STEP 1: To show the field list, Right Click on your Pivot Table and select Show Field List.

Show & Hide Field List in Excel Pivot Table

 

Your PivotTable Field List (renamed to PivotTable Fields in Excel 2013 and onwards) is now showing!

Let us show in the next step how to hide this.

Show & Hide Field List in Excel Pivot Table

 

STEP 2: To hide the Field List, Right Click on your Pivot Table and select Hide Field List.

Show & Hide Field List in Excel Pivot Table

 

Your Pivot Table Field List is now hidden!

Show & Hide Field List in Excel Pivot Table

 

Using Ribbon

The field list for Pivot Table can easily be toggled on and off using the ribbon menu.

 

Follow the steps below to show/hide Pivot Table Field List using the ribbon menu:

STEP 1: Click on any cell in the Pivot Table.

Show & Hide Field List in Excel Pivot Table

STEP 2: Go to PivotTable Analyze > Field List.

Show & Hide Field List in Excel Pivot Table

STEP 3: The field list will appear next to the Pivot Table!

Show & Hide Field List in Excel Pivot Table

You can hide the list using the same steps.

STEP 4: Go to PivotTable Analyze > Field List.

Show & Hide Field List in Excel Pivot Table

This will hide the field list section from the worksheet!

Show & Hide Field List in Excel Pivot Table

 

Using VBA

You can even use VBA to show and hide Pivot Table Fields in Excel. Let’s see how it can be done:

STEP 1: Press Alt + F11 to open the window for Microsoft Visual Basic for Applications.

Or, Go to Developer > Visual Basic.

Show & Hide Field List in Excel Pivot Table

STEP 2: Go to Insert > Module and copy-paste the following code in it.

Show & Hide Field List in Excel Pivot Table

STEP 3: Copy-paste the following code in it:

Sub HideFieldList()
ActiveWorkbook.ShowPivotTableFieldList = False
End Sub

Show & Hide Field List in Excel Pivot Table

STEP 4: Press Ctrl + S to save the Excel Workbook.

STEP 5: In the dialog box, select No to save the WorkBook as Macro enabled.

Show & Hide Field List in Excel Pivot Table

STEP 6: In the Save as dialog box, select Excel Macro-Enabled Workbook from Save as type dropdown. Click Save.

Show & Hide Field List in Excel Pivot Table

Open this Macro-Enabled Workbook!

STEP 7: Go to Developer > Macros

Show & Hide Field List in Excel Pivot Table

STEP 8: Select HideFieldList and Click Run.

Show & Hide Field List in Excel Pivot Table

This will hide the field list section from the worksheet!

Show & Hide Field List in Excel Pivot Table

 

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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Show & Hide Field List in Excel Pivot Table | MyExcelOnline
Bryan

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

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!