To find an Excel table’s name, click any cell inside the table and open the contextual Table Design tab; in the Properties group, read the Table Name box. To see several names at once, open Formulas > Name Manager, where table names are listed with other workbook names.
Where the Table Name box is
In Excel for Microsoft 365 on Windows, the Table Design tab appears on the ribbon only when the active cell is part of an Excel table. Click one of the table’s cells, then look near the left side of the Table Design ribbon for the Properties group and its Table Name field. The field contains the selected table’s current name, such as Table1 or Sales.
This is a contextual tab: if you click outside the table, Table Design disappears. That can make it seem as if the command is missing, especially when the sheet has many columns or the selected cell is just beyond the table edge. Click a clearly populated cell within the table, rather than a nearby worksheet cell, to bring the tab back.
The field is also where you rename the table. Select the existing text, type the replacement name, and press Enter. The new name applies to the table throughout the workbook, including formulas that use its structured references.
How to see all table names in a workbook
If you need an inventory rather than the name of the table currently selected, use Formulas > Name Manager. On Windows, the keyboard shortcut is Ctrl+F3. Name Manager lists workbook names, including table names, and shows details such as what each name refers to. Look for entries whose references identify a table, rather than assuming every entry in the list is a table: the list can also contain names created for ranges or formulas.
For example, a workbook might contain a table called Orders and a separate defined name called TaxRate. Both can appear in Name Manager, but they serve different purposes. Orders identifies an Excel table with headers and rows; TaxRate might refer to one cell or a formula. Select a table entry to inspect its reference, then use the Table Design tab when you want to change the table’s name.
Another quick way to identify a table is to click one of its cells and read the Table Name box. This is reliable when you are checking a particular table, but it is less convenient for comparing many tables because you have to select each one in turn. Name Manager is more useful for scanning a workbook, while Table Design is the clearest place to confirm or change an individual table name.
How Excel table names work
An Excel table is a structured data range created with Insert > Table or Home > Format as Table. It has a header row and built-in table behavior, such as filter buttons and the ability to extend when you add data next to or below it. A table’s name identifies that object; it is not the same thing as a worksheet name, a column heading, or a cell address.
Excel often assigns a default name such as Table1 when a table is created. If the workbook already has tables, the next default name may use a different number to keep the table names distinct. You can replace a generic name with something that explains the data, such as Customers, Inventory, or MonthlySales. Useful names make formulas easier to read and make it simpler to identify the right object later.
Table names are workbook-level identifiers, not names that are separately scoped to each worksheet. A table called Customers on one sheet prevents another table in the same workbook from using that same table name. The name itself does not change the sheet the table is on or alter its data; it gives Excel and the workbook’s formulas a consistent way to refer to the table.
How to rename a table safely
- Click a cell inside the table you want to rename.
- Choose Table Design on the ribbon.
- In Properties, click the Table Name box.
- Replace the current name with a valid, descriptive name and press Enter.
For instance, if a table contains monthly sales records, a name such as MonthlySales is more informative than Table4. Renaming the table does not rename its worksheet, and renaming the worksheet does not rename the table. Keeping these two names distinct can prevent confusion when navigating a workbook with several sheets and tables.
Excel updates references that use the table’s name when you rename it, so formulas built with structured references generally continue to point to that table. Even so, it is sensible to check important formulas, charts, queries, or other workbook features after a substantial cleanup. In particular, a name typed as plain text inside a formula or external process is not necessarily a live table reference that Excel can update.
Rules for valid table names
Excel table names must follow naming rules, so a name that looks natural in a sentence may not be accepted. In general, start the name with a letter, an underscore, or a backslash; use letters, numbers, periods, or underscores in the name; and do not include spaces. Table names also cannot look like cell references such as A1, and table names must be unique in the workbook.
Examples that work include Sales, Q1_Orders, and Store.2026. Names such as Sales Data contain a space, while 2026Sales begins with a number, so they are not suitable table names. If you want words separated visibly, use an underscore or join them in a readable way, as in Sales_Data or SalesData.
Table names are not case-sensitive for identifying the table, so changing capitalization does not create a separate name. A clear, consistent style matters more than choosing uppercase or lowercase. Avoid names that are so abbreviated that another person cannot tell what the table contains, and avoid changing names casually if documentation or outside processes depend on them.
Why table names matter in formulas
Table names let Excel use structured references, which describe table columns by name instead of by worksheet coordinates. That can make a formula easier to understand and less dependent on the table’s location. For example, a formula can refer to the Amount column in a table named Sales rather than to a particular block of cells.
With a table named Sales and an Amount column containing 120, 80, and 50, the formula =SUM(Sales[Amount]) returns 250. The expression identifies the Amount data in Sales; it does not require the reader to work out which worksheet column contains those values. If rows are added to the table, structured references are designed to follow the table’s data as it expands.
Structured references have specific parts. The table name identifies the table, and square brackets enclose a column name or a special table item. For example, Sales[Amount] points to that column’s data, while references using labels such as #Headers or #Totals can identify particular parts of a table. Exact syntax depends on whether the formula should include the header, data rows, totals row, or the current row.
A common misconception is that every formatted range has a table name. Applying cell colors, borders, or number formats does not by itself create an Excel table. If clicking the range does not show the contextual Table Design tab, it may be an ordinary range rather than a table. Create or convert it to a table with Insert > Table if table features and a table name are needed.
Common problems when looking for a name
- The Table Design tab is missing: Click inside the table, not just on its worksheet or next to it. If the range has only been formatted, convert it into a table first.
- The name box is hard to spot: The Table Name field is on the contextual ribbon, not the worksheet’s Name Box beside the formula bar. Those are different controls.
- Excel rejects the name: Remove spaces, do not begin with a number, and avoid a name that resembles a cell reference. Also check that another table is not already using it.
- A formula does not recognize the name: Check the spelling and punctuation, including the column header inside the square brackets. A renamed column can also affect references that use its header.
- A table name seems to have vanished: If you are in Name Manager, remember that the list also contains defined names. Inspect the reference details and select the actual table to confirm its name in Table Design.
One other point of confusion is the worksheet’s visible tab name. A sheet called SalesData may contain a table called Table1, while a sheet called Sheet1 may contain a table called Sales. Changing either name affects a different object. If a formula is difficult to read, check both the table name and the column header before editing it.
Excel for Mac and Excel for the web
The instructions above describe Excel for Microsoft 365 on Windows. In Excel for Mac, select a cell in the table and look for the contextual Table or Table Design tab; the exact label can vary with the interface version. Use its table-name field to inspect or rename the selected table. The Windows shortcut Ctrl+F3 has a different Mac equivalent in some keyboard layouts and may be affected by macOS settings, so use Formulas > Name Manager from the ribbon if the shortcut is not available.
In Excel for the web, select a cell in the table to reveal its contextual table options, then use the table-name field on the ribbon. The web interface can arrange commands differently from the Windows desktop ribbon, but the underlying distinction remains: select the table to see its name, and use Name Manager where available to review workbook names. If you do not see a table-specific tab, check that the selection is inside an actual table.
Menus and ribbon layouts can shift as Microsoft updates Excel. The table name itself is a workbook feature, but the location of a contextual command may look slightly different between desktop and browser versions. When following instructions from a different version, search the contextual table tab for the field labeled Table Name rather than looking for the worksheet tab name.
Frequently Asked Questions
Where do I find a table name in Excel?
Click a cell in the table, then open Table Design and read the Table Name field in the Properties group. The tab appears when a table cell is selected.
How can I see all table names in Excel?
Open Formulas > Name Manager. It lists table names alongside other defined names, so inspect the reference details to distinguish tables from named ranges or formulas.
Can I change a table name without changing the sheet name?
Yes. Rename the table in the Table Name field on Table Design. The worksheet tab name is a separate setting and remains unchanged.
Why can’t I see Table Design in Excel?
The active cell may be outside the table, or the data may be a formatted range rather than an actual Excel table. Click within a table or create one with Insert > Table.
Can two Excel tables have the same name?
No. Table names must be unique within a workbook. Choose a different name that follows Excel’s naming rules if the name is already in use.
Related
- Excel Template for a Budget Plan: Build Your Own
- Excel Meal Planning Template: A Practical Guide
- Excel MAXIFS: Find the Highest Value for Each Date
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Filter by Date Range: Steps and TipsYes. In Google Sheets, select your data, choose Data > Create a filter, then use the date column’s…
- Excel Column Length: Rows, Width, and LimitsAn Excel column runs through 1,048,576 rows, so it can hold up to 1,048,576 cells. If by “length”…
- How to Get Rid of the Search Bar in ExcelTo hide Excel’s large Search box in Microsoft 365 for Windows, go to File > Options > General,…
- How to Make Serial Numbers in Excel: 4 Easy MethodsTo make serial numbers in Excel, enter 1 and 2 in the first two cells, select both, then…
- How to Clear Search Cache in OutlookTo clear Outlook’s saved search terms in classic Outlook for Windows, click the search box, open the Search…
- Excel Conditional Formatting: Highlight Dates 1 Year LaterTo highlight a date exactly one year from today in Excel, select the date cells and create a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.