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

Group By Custom Dates With Excel Pivot Tables In my previous Group By Month post, we grouped our Sales by each month.However the cool thing with Excel is that we can take that a step further and customize our grouped date range!In the example below I show you how to get the Sales Grouped by Custom Dates:  ...
Count VS Sum in Pivot Tables The #1 complaint that I get from Pivot Tables is "Why do my values show as a Count of rather than a Sumof ?"Well there are three reasons why this is the case:1. There are blank cells in your values column within your data set; or2. There are "text" cells in your value...
Show The Percent of Parent Total With Excel Pivot ...  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 TOTAL calculation.In the example below I show you how to get the Percent of a Product Total i.e The % Sales of each Product ...
The Ultimate Guide to Excel Pivot Table Slicers Slicers were first introduced in Pivot Tables in Excel 2010 for Windows and Excel 2016 for Mac.Pivot Table Slicers are a visual filter in the form of an interactive button.  There are several cool things that you can do with Pivot Table Slicers, like customize them, filter th...