How to get pivot table menu back in Excel

You can watch a video tutorial here.

Pivot tables are one of the most useful tools in Excel for summarizing and analyzing data. When a pivot table is created, Excel provides a set of tools for changing and designing the pivot table. These tools are available on the pivot table menu that is not always displayed.

Step 1 – Look for the pivot table menu

– Select a cell outside the pivot table
– Look for the menu
– The menu is not available

Step 2 – Summon the menu

– Select any cell in the pivot table
– The menu is displayed on the menu bar