Why does Excel create a separate name for a table rather than renaming default?

[wsnow]

I have a spreadsheet with three sheets and one table on each sheet. The default names are Table1, Table2, Table4. I used the cell name field to "rename" these tables to match the sheet name, but rather than replace the Table1, etc. I now show a list of six names, the original "TableX" name, and the three new ones I want to use. How do you get Excel to actually replace the default names rather than assigning an additional name? Will Excel not allow the table name and sheet name to be the same? Also, is it possible to delete a table name once it has been created?


Thanks.

[p45cal]

By using the 'cell name field' you're giving the selected range a name. You can name the same range multiple names, and all will be valid, say, in a formula. But you're not changing the table name. Do this on the Table Design tab of the ribbon, Properties section, press Enter once you've changed it, it won't keep the old name:


2024-06-04_231315.jpg

[wsnow]

Duh, thanks. I have used that before and was wondering why I wasn't seeing that second box up top. Brain fart moment. Thanks.