Rename an Excel table

Each time you create a table, Excel assigns a default name to the table according to this naming convention: Table1, Table2, Table3, and so on. To make it easier to refer to a table, for example, in a workbook that contains many tables, you can name each table.

Note: The screen shots in this article were taken in Excel 2016. Your view may differ slightly if you have a different version of Excel, but the functionality is the same (unless otherwise noted).

To rename a table:

  1. Click on the table.

  2. Go to Table Tools > Design > Properties > Table Name.

    On a Mac, go to the Table tab > Table Name.

  3. Highlight the table name and enter a new name.

    Image of the Name Box in the Excel Formula Bar to rename a table

Tips: 

  • All of your tables will be shown in the Address bar, which appears to the left of the Formula bar. When you select any table from the list, Excel will automatically jump to that table—even if it's on another worksheet.

  • Excel Address bar to the left of the Formula bar

Important notes for names

  • Use valid characters  Always begin a name with a letter, an underscore character (_), or a backslash (\). Use letters, numbers, periods, and underscore characters for the rest of the name.

    Exceptions: You can’t use "C", "c", "R", or "r" for the name, because they’re already designated as a shortcut for selecting the column or row for the active cell when you enter them in the Name or Go To box.

  • Don’t use cell references — Names can’t be the same as a cell reference, such as Z$100 or R1C1.

  • Don’t use a space to separate words — Spaces cannot be used in the name. Consider how you can write the name using no spaces. Or, use an underscore character (_) or a period (.) as word separators. Examples: DeptSales, Sales_Tax or First.Quarter.

  • Maximum 255 characters — A table name can have up to 255 characters.

  • Use unique table names — Duplicate names aren’t allowed. Excel doesn’t distinguish between upper and lowercase characters in names, so if you enter “Sales” but already have another name called “SALES" in the same workbook, you’ll be prompted to choose a unique name.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Overview of Excel tables

Video: Create an Excel table

Total the data in an Excel table

Resize a table by adding or removing rows and columns

Excel table compatibility issues

Export an Excel table to SharePoint

Convert an Excel table to a range

Filter data in a range or table

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×