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.
But, in this tutorial, we will learn quick steps to rename a table with a custom name.
Change the Name of an Excel Table
- First, select any of the cells from the table.
- After that, go to the “Table Design” tab.
- Next, click within the table name input bar and type the name you want to apply.
- In the end, hit enter to apply the name entered.
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
- First, go to the Formulas Tab and click on the “Name Manager” option.
- From there, select the table you want to rename and click edit.
- Now, from the name input bar, change the name.
- In the end, click OK to save, and then click on Close.
Tip: By using name manager, you can manage all tables that you have in a workbook.
Notes on Table Name
- The name of a table needs to be a hard code value. You can’t refer to a cell for the name.
- 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.
- You need to start the name with a letter, underscore (_), or a backslash (/).
- The length of the name can be up to 255 characters, but you hardly need to use a name that long.
- The name of each table in a workbook needs to be unique (if you have multiple tables).
More Tutorials
- Excel Quick Analysis Tool
- Apply Multiple Filters to Columns
- Highlight Top-Bottom N Values in Excel
- Insert Checkbox in Excel
- Merge Cells in Excel without Losing Data in Excel
- Multiply in Excel using Paste Special Option
- Add and Use Barcode in Excel
- Default Font in Excel
- Filter by Color in Excel
- Use Column Numbers in Excel
- Grey Out Cells in Excel
- Make Cells Bigger in Excel
- Remove Dashes in Excel
⇠ Back to Advanced Excel Tutorials