 | |
| Why is the Pivot Table Field List Missing and How to Get It Back |
Did your pivot table field list disappear? In this video I explain how to get the field list back if it is not showing. The quickest way to get it back is to Right-click a cell inside the pivot table and select "Show Field List" from the menu.
The field list is contextual and will only appear when a cell is selected inside the pivot table. It can also be turned on or off in the Analyze/Options tab of the Ribbon by clicking the Field List button. Here are the instructions:
- Select any cell inside the pivot table.
- Go to the Analyze/Options tab on the right side of the ribbon. If you are using Excel 2010/2007 it will say options. The tab has been changed to Analyze in new versions.
- Click the Field List button in the show section to enable the field list. This is a toggle button that can be turned on/off. The close button in the top-right corner of the field list window also turns the toggle off.
Related Topics:
Post a Comment