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!

YouTube video
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 WORKBOOK

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!

how to show pivot table fields

 

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

STEP 2: Go to PivotTable Analyze > Field List.

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

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

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

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

This will hide the field list section from the worksheet!

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

 

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

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

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

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

Sub HideFieldList()
ActiveWorkbook.ShowPivotTableFieldList = False
End Sub

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

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

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

Open this Macro-Enabled Workbook!

STEP 7: Go to Developer > Macros

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

STEP 8: Select HideFieldList and Click Run.

Show & Hide Field List in Excel Pivot Table | MyExcelOnline

This will hide the field list section from the worksheet!

Show & Hide Field List in Excel Pivot Table | 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 Formulas, Pivot Tables, Power Query, and Macros & VBA!

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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