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 🙂

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

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!

Show & Hide Field List in Excel Pivot Table

How to Show / Hide Field List in Excel Pivot Table

Show & Hide Field List in Excel Pivot Table

Helpful Resource:

Excel Pivot Table

 

 

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

Share on Google+

Google+

Related Posts

Show The Percent of Difference From Previous Years...  I am sure that your boss has asked you to come up with a Year on Year variance report at some stage.  There are a couple of ways to get him/her an answer.One is using Formulas, but that will take time to set up and you are exposed to errors!The other method is t...
Refresh All for Excel Pivot Tables When the information in your data source gets updated or changed, you need to Refresh your Pivot Table to see those changes in your Pivot Table.How about if you have multiple Pivot Tables from the same data source in the same workbook? Or;Pivot Tables that are created fro...
Show The Percent of Parent Row Total With Excel Pi... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT ROW TOTAL calculation.This is a new calculation in Excel 2010 and onwards.This option will immediately calculate the percentages f...
Clear & Delete Old Pivot Table Items Have you ever cleared, deleted or replaced your Pivot Table data/items but they still shows inside your Pivot Table filters?What gives??Well, you can easily clear your Pivot Table's old items from your Pivot Table's memory or cache.In our example below we have our Piv...