Show & Hide Field List in Excel Pivot Table

Have you ever experienced sudden disappear of field list while working in Pivot Table? it’s very annoying with the Excel but don’t worry here I got you a solution for this; you can solve this easily within 2 steps given below.

Here for my example, sample Pivot Table is given below:

Show & Hide Field List in Excel Pivot Table

STEP1: Show Field

Firstly, right-click on your Pivot Table and select the Show Field List, to show the field list.

Show & Hide Field List in Excel Pivot Table

Your PivotTable Field List and in Excel 2013 and onwards it gets renamed to PivotTable Fields will be showing.

STEP2: Hide Field

Now Right Click on your Pivot Table and select Hide Field List; to hide the Field List.

Show & Hide Field List in Excel Pivot Table
Here you got Your hidden Pivot Table Field List.