An Excel table name is the workbook-level identifier assigned to a formatted Excel table, such as Table1 or Sales. To find or change it in Excel for Microsoft 365 on Windows, click a cell in the table, open the Table Design tab, and use the Table Name box in the Properties group.
What an Excel table name identifies
An Excel table is a structured range of data with features such as header filters, consistent formatting, and formulas that can expand as rows are added. Its table name identifies that entire table, making it possible to refer to the data in formulas without relying only on cell addresses. Excel gives a newly created table a default name such as Table1, Table2, or another available number in that workbook.
The table name is not the same thing as a worksheet name, a column heading, or a named range. For example, a worksheet might be named January, its table might be named Orders, and a column in that table might be headed Order Date. Those names describe different things and are used in different parts of Excel.
A clear table name is especially helpful when a workbook contains several datasets. Names such as Orders, Products, and Staff communicate more than the automatic names Table1, Table2, and Table3. Naming a table does not change its data or appearance; it gives the table a meaningful reference for formulas and other workbook features.
How to find the current table name
Click any cell inside the table. Excel displays the contextual Table Design tab on the ribbon. In its Properties group, look for the Table Name box. The text in that box is the table’s current name. If the tab does not appear, first check that the selected cell is actually inside an Excel table rather than an ordinary range with similar formatting.
Another way to confirm a table’s identity is to inspect a formula that refers to it. Structured references use the table name, often followed by a column heading in square brackets. For example, a formula referring to a column in a table called Orders may contain Orders[Amount]. This can help identify the table, but the Table Design box is the most direct place to check its name.
On Excel for Mac, select a cell in the table and look for the contextual Table Design tab and its table-name control; ribbon placement can differ slightly by window size and Excel build. Excel for the web also provides table tools when a table cell is selected, though the available ribbon layout may vary. The steps above describe Microsoft 365 for Windows.
How to rename an Excel table
- Click a cell inside the table you want to rename.
- Select Table Design on the ribbon.
- Click the Table Name box in the Properties group.
- Select or delete the existing name, type the new name, and press Enter.
For example, you could rename an automatically named table to MonthlySales. Keep the name concise but specific enough to distinguish it from other tables. If you have several tables containing sales data, names such as OnlineSales and StoreSales are more informative than repeated generic labels.
Renaming a table does not rename the worksheet or change the table’s column headings. Excel normally updates structured references in workbook formulas when you rename the table, so a formula using the old table name continues to refer to the same table. However, a table name typed as ordinary text in a note, external document, or other non-formula field is just text and will not necessarily update automatically.
Rules for choosing a valid table name
Excel table names have naming restrictions. In particular, a name cannot contain spaces and cannot be written like a cell address. A name such as Sales Data is invalid because it contains a space; Sales_Data or SalesData works instead. A name that looks like a cell reference, such as A1, is also not allowed.
- Start the name with a letter, an underscore, or a backslash; do not start it with a number.
- Use letters, numbers, underscores, or periods to make names readable and easy to type.
- Avoid spaces and punctuation that Excel does not permit in names.
- Choose a distinct name for each table in the workbook.
- Prefer a descriptive name that will still make sense if the table grows or moves.
Column headings follow different rules from table names. A heading such as Order Date can contain a space, and Excel handles it in structured references. In a formula, the table name and column heading appear as separate parts, as in Orders[Order Date]. Do not remove useful spaces from every heading just because the table name itself cannot contain them.
Using table names in formulas
Table names are most visible in structured references. Instead of referring to a fixed range such as D2:D50, a formula can refer to a table column by its table and heading. Structured references are easier to interpret when data is rearranged, and they generally expand with the table as records are added.
Suppose a table named Orders has a column headed Amount. With that table column containing the values 120, 80, and 50, a formula entered outside the table can total the column:
With the table named Orders and its Amount column containing 120, 80, and 50, enter:
=SUM(Orders[Amount])
The result is 250. The reference Orders[Amount] means the data in the Amount column of the table named Orders; it is not a reference to the worksheet called Orders.
Structured references can also make row-by-row calculations readable. For instance, a table named Orders might have columns called Quantity and UnitPrice. In a calculated column of that same table, the current row can be expressed with the at-sign notation:
With the formula entered in a calculated column of Orders, and the current row showing Quantity 3 and UnitPrice 12, enter:
=[@Quantity]*[@UnitPrice]
The result for that row is 36. Excel can fill the calculated formula down the table column. The notation [@Quantity] means the value in the Quantity column on the current row, not the entire column.
Structured references have several forms. Orders[Amount] refers to the data column, while a reference that includes a special item such as Orders[#Headers] refers to the header row. Excel often creates the appropriate structured reference when you select table cells while building a formula. This reduces the chance of mistyping a name or heading.
What happens when a table changes
Tables are designed to grow with their data. When a record is added directly below a table, Excel commonly expands the table to include it, and references to the table’s data columns include the new row. If a total uses Orders[Amount], it can account for added records without manually changing an endpoint such as row 50. Expansion behavior can depend on how the data is entered and on Excel’s settings, so check that the new record is actually part of the table.
Table names also help formulas remain understandable if the table moves to another part of a worksheet. A reference to Orders[Amount] identifies the table column, while a reference such as D2:D50 depends on its location. This does not mean every formula or workbook connection will adapt to every structural change; deleting a referenced column, for example, can still break formulas that need it.
When you copy a formula containing a structured reference, Excel applies its table-reference rules. A reference to a whole table column is useful for a summary outside the table, while a current-row reference is useful inside a calculated column. If a formula returns an unexpected result, check whether it is using the intended table name, heading, and reference type.
Table names versus worksheet names and named ranges
A worksheet name appears on a sheet tab and identifies a sheet. A table name identifies a particular table on a worksheet. A named range is a separate label assigned to a cell or range, managed through Excel’s name features. These concepts can all make formulas easier to read, but they are not interchangeable.
For example, a workbook can contain a worksheet named Archive and a table named Orders on that sheet. Referring to Orders[Amount] targets the table’s Amount column; it does not mean the whole Archive sheet. If you need to refer to a table, use its table name and, where appropriate, a column heading. If you need to refer to a sheet, use a sheet reference instead.
Do not look for a table’s name by renaming its worksheet tab. Changing the sheet name will not change the table name, and changing the table name will not rename the sheet. Keeping these labels distinct makes larger workbooks easier to maintain and helps prevent confusion when multiple tables share a worksheet.
Common table-name problems and fixes
If Excel rejects a name, first check for spaces, a leading number, or a name that resembles a cell address. Also confirm that you are editing the Table Name box while a table cell is selected. Typing a proposed name into a worksheet cell or the sheet tab changes something else, not the table’s identifier.
- The Table Design tab is missing: Select a cell inside the table. If it still does not appear, the range may not be an Excel table.
- The name is rejected: Replace spaces with underscores or remove invalid punctuation, and choose a name that is not a cell reference.
- A formula shows an error after editing: Check that the table and column names are spelled as they appear in Excel, and that the referenced column still exists.
- The new row is not included: Verify that it is part of the table, rather than merely formatted to look like the next row.
- You cannot tell which table a formula uses: Click the table and inspect the Table Name box, then compare it with the name in the formula.
Column headings can also cause confusion. Excel may adjust duplicate or blank headings when it creates a table so that its columns can be referenced distinctly. When a structured reference behaves unexpectedly, inspect the actual header text in the table rather than assuming it exactly matches the original range heading.
Frequently Asked Questions
What is the default name of an Excel table?
Excel assigns an available name such as Table1 when you create a table. The exact number depends on the other table names already used in the workbook.
Can an Excel table name contain spaces?
No. Use a name such as Quarterly_Sales or QuarterlySales instead of Quarterly Sales. Column headings can contain spaces even though table names cannot.
How do I see all the tables in a workbook?
Select each table and read its name in the Table Design tab’s Table Name box. Excel’s Name Manager is primarily for defined names and is not the most direct way to inspect table names.
Does renaming a table break its formulas?
Excel normally updates workbook formulas that use structured references when the table is renamed. Check formulas or connections that store the old name as plain text, since text is not the same as a formula reference.
Can two tables have the same name?
No. Table names must be distinct within a workbook. If Excel says a name is already in use, choose another descriptive name, such as NorthOrders or WestOrders.
Is a table name the same as a named range?
No. A table name identifies an Excel table and supports structured references such as Orders[Amount]. A named range is a separate label for a cell or range and is managed as a defined name.
Related
- Protect Sheet in Excel: Allow Editing in Certain Cells
- Jira Merge Table Cells: Steps and Limitations
- Conditional Formatting: Highlight Duplicates in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Extract Text in an Excel Cell: Formulas and Steps That WorkTo extract part of a cell’s text, use a formula such as TEXTBEFORE for text before a separator,…
- Highlight Upcoming Dates in Excel with a Formula RuleTo highlight dates coming up in the next 30 days, select the date cells and create a formula-based…
- Remove Spaces in Excel Rows: Trim, Find, and ReplaceTo clean spaces at the start or end of text, or reduce repeated spaces between words, use Excel’s…
- Identify Offsetting Entries in Excel With Formulas and ChecksTo flag entries with an equal and opposite amount, put the date in column A, account in B,…
- VLOOKUP in Excel: Return a Value from Another CellTo make VLOOKUP return a value from another cell, look up a key in the leftmost column of…
- Box Plot Formula: Quartiles, IQR, and WhiskersA box plot has no single formula: it is built from a five-number summary—minimum, first quartile (Q1), median,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.