When you create a Pivot Table, Microsoft Excel automatically names the Pivot Table as PivotTable1 and the next Pivot Table that you create is named as PivotTable2.
Instead of following this default naming convention, you can change Pivot Table Name to something meaningful and relevant to the data on the Pivot Table.
For example, Pivot Tables with names like “January Sales” or “Sales by Months” appear more meaningful, compared to default Excel generated names (PivotTable1 and PivotTable2)
Another advantage of changing the default Names of Pivot Tables is that it makes it easy for you to reference the Name of the Pivot Table in formulas and in Visual basic coding.
Change Pivot Table Name
It is really easy to change Pivot Table Name in Microsoft Excel. You can find below the steps to change the name of a Pivot Table, along with relevant screenshots.
Steps to Change Pivot Table Name
As mentioned above, it is really easy to change Pivot Table name in Microsoft Excel.
1. Right-click anywhere on the Pivot Table and click on PivotTable Options… in the menu that appears.
2. On Pivot Table Options screen, click in the box next to PivotTable Name and type the New Name for your Pivot Table. In our case, we have named our Pivot Table as “January Sales by Store”.
3. Once you are done, click on the OK button to save this change.