Rename or Delete an Excel Table Name in Name Manager
Question details
The user wants to rename or remove an automatically created name that belongs to an Excel table.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A table name appears in Name Manager, and the user wants to change or remove it.
- Observed behavior
- The name is associated with an Excel table and cannot be deleted independently through Name Manager.
Open Formulas > Name Manager and identify the table name you want to change or remove. Decide whether you need to keep the table features, because converting the table to a range removes those features.
Rename the table using Table Design
Use this option to change the name while keeping the Excel table and its features.
Click any cell in the table associated with the name.
Select the Table Design tab on the ribbon.
In the Table Name box, enter a unique, valid name without spaces, then press Enter.
Open Formulas > Name Manager and confirm that the table appears under its new name.

Remove the table name by converting the table to a range
Use this option when you no longer need the table object or its features.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files into WPS; it does not change Excel's table-name behavior.

Frequently Asked Questions
Why does my Excel table appear in Name Manager?
Excel assigns a name to each table, including automatically generated names. Open Formulas > Name Manager to review the names in the workbook.
Can I delete a table name without removing the table?
No. A table name belongs to the table and cannot be deleted independently in Name Manager. To keep the table, select a table cell and rename it under Table Design > Table Name.
What happens when I convert an Excel table to a range?
Table Design > Convert to Range removes the table object and its table-specific features. The worksheet data remains in the range.
Why won't Excel accept my new table name?
The name must be unique and follow Excel's naming rules. In Table Design > Table Name, try a name without spaces that does not look like a cell reference.




