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:
STEP1: Show Field
Firstly, right-click on your Pivot Table and select the Show Field List, to show the field list.
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.