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 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:

• Using Right Click
• Using Ribbon
• Using VBA

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:

 

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

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

 

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.

 

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

 

Your Pivot Table Field List is now hidden!

 

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.

STEP 2: Go to PivotTable Analyze > Field List.

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

You can hide the list using the same steps.

STEP 4: Go to PivotTable Analyze > Field List.

This will hide the field list section from the worksheet!

 

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.

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

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

Sub HideFieldList()
ActiveWorkbook.ShowPivotTableFieldList = False
End Sub

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.

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

Open this Macro-Enabled Workbook!

STEP 7: Go to Developer > Macros

STEP 8: Select HideFieldList and Click Run.

This will hide the field list section from the worksheet!

 

Helpful Resource:

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

You can learn more about how to use Excel by viewing our FREE Excel webinar training on Formulas, Pivot Tables, Power Query, and Macros & VBA!