How to Rename a Table in Excel

puneet-gogia-excel-champs-09-06-23

- by Puneet

When you apply an Excel table to a set of data, Excel allows you to name it. But by default, a generic name is given to a table.

rename-excel-table

But, in this tutorial, we will learn quick steps to rename a table with a custom name.

Change the Name of an Excel Table

  1. First, select any of the cells from the table.
  2. After that, go to the “Table Design” tab.
  3. Next, click within the table name input bar and type the name you want to apply.
  4. In the end, hit enter to apply the name entered.
table-design-tab

Alert: You can’t just delete the name of a table, you need to specify a new name for it.

Use Name Manager to Rename an Excel Table

  1. First, go to the Formulas Tab and click on the “Name Manager” option.
    click-name-manager-option
  2. From there, select the table you want to rename and click edit.
    select-the-table-to-rename
  3. Now, from the name input bar, change the name.
    enter-the-new-name
  4. In the end, click OK to save, and then click on Close.
    click-on-close

Tip: By using name manager, you can manage all tables that you have in a workbook.

Notes on Table Name

  1. The name of a table needs to be a hard code value. You can’t refer to a cell for the name.
  2. You can’t use a space in between the name of the table. But you can use a hyphen, or underscore to make it readable.
  3. You need to start the name with a letter, underscore (_), or a backslash (/).
  4. The length of the name can be up to 255 characters, but you hardly need to use a name that long.
  5. The name of each table in a workbook needs to be unique (if you have multiple tables).