How to open pivot table in excel

The Pivot Table feature is used by many Excel users – beginners as well advanced.

One thing that often troubles new Pivot Table users is when they find that a Pivot Table Fields list (some people call this Pivot Table Fields menu) goes missing.

You can’t do much with a Pivot table if you do not see the Fields list, and it’s not very intuitive on how to get it back (at least for new Excel users)

In this short tutorial, I will show you two simple ways you can use to get back the Pivot Table Fields list.

How to Show Pivot Table Fields (Get Back Pivot Table Fields Menu)

Let’s look at two simple ways to get the Pivot Table Fields task pane to show again:

Using the Right-Click Method

The easiest way to get the Pivot Table Field list back would be to right-click on any of the cells in the Pivot table and click on the ‘Show Field List’ option.

Below I have a Pivot Table for which the field lists have been turned off, and I want to get it back.

Here are the steps to do this:

how to see pivot table options
how to see pivot table options in excel