In the screen shot below, you can see a comparison of the box sizes. PivotTable Options name box is bigger than the one on the Analyze tab, so you might want to make changes here, except for very short names.

In the right-click menu, click PivotTable Options.Īt the top of the PivotTable Options window, there is a box that shows the current name of the selected pivot table.

Right-click on any cell in the pivot table.

NOTE: There’s no setting that lets you increase the size of the pivot table name box on the Analyze tab.Īnother place to see the pivot table name is in the PivotTable Options dialog box. The name box is small though, and the end of the name is not visible. In the screen shot below, I changed the name to “PivotTableNEW”.

Click anywhere outside of the name box, to complete the name change (you don’t have to press Enter).

Type a new name, or make a change to the existing name.You can use that pivot table name box to make a quick change to the pivot table name: When a pivot table cell is selected, you can see the pivot table’s name at the left end of the Analyze tab on the Excel Ribbon. You can see written instructions and screen shots on my Contextures website.

Watch this video to see the steps for creating a pivot table, using the Recommended Pivot Tables command. Excel will create a name, and it’s easy to change the pivot table name at any time. While you’re building an Excel pivot table, you don’t have an option to set a name for your pivot table. You can leave that automatic name as it is, or change an Excel pivot table name to something more meaningful, such as “SalesPivot”. When you build a pivot table, Excel automatically creates a numbered name for it, such as PivotTable1.

Excel mac pivot table