![excel for mac delete table names excel for mac delete table names](https://excelsemipro.com/wp-content/uploads/2011/04/Name-Box-Both.png)
NOTE: Even though those odd characters are allowed in pivot table names, I recommend using alphanumeric characters only, to avoid problems when creating macros that refer to pivot tables by name. You can even name a pivot table with a question mark, or one space character!įor example of what’s allowed, I changed a pivot table to this strange mix of characters, with no problems. So far, I haven’t found any characters that are restricted for pivot table names.
![excel for mac delete table names excel for mac delete table names](https://cdn.extendoffice.com/images/stories/doc-excel/ttw-modules/ad-clear-all-cell-formats-1.png)
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.
![excel for mac delete table names excel for mac delete table names](https://support.content.office.net/en-us/media/8f3a1fdc-80dd-4aa0-b6c3-7ef37b931f9f.png)
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.