Office Settings & Configuration

Rename or Delete an Excel Table Name in Name Manager

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 868 views

Question details

The user wants to rename or remove an automatically created name that belongs to an Excel table.

Rename or Delete an Excel Table Name in Name Manager
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.
Before you start

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.

Solution 1Recommended

Rename the table using Table Design

Use this option to change the name while keeping the Excel table and its features.

1
Select the table

Click any cell in the table associated with the name.

2
Open Table Design

Select the Table Design tab on the ribbon.

3
Enter a new name

In the Table Name box, enter a unique, valid name without spaces, then press Enter.

4
Check the result

Open Formulas > Name Manager and confirm that the table appears under its new name.

Rename the table using Table Design
Free Microsoft Office alternative

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.

Open and edit Excel XLSX and XLS filesWork with spreadsheet tables and formulas in a familiar interfaceMove existing Office files into a lightweight workspaceUse a free office suite for everyday spreadsheet tasks
microsoft office alternative - wps office

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.