Excel Find Table Names: Where to Look and How

How-to basics · Updated November 19, 2026

To find an Excel table’s name, click any cell in that table and look at the Table Name box on the Table Design tab. To find every table name in a workbook, use that same box for each table, or create a list with a short VBA macro if the workbook contains many tables.

Find a table name from the ribbon

In Excel for Microsoft 365 on Windows, click inside the table you want to identify. The contextual Table Design tab appears on the ribbon. In its Properties group, read the value in the Table Name box. That value is the table’s current name; it is not necessarily the worksheet name or the heading above the table.

  1. Click a data cell or a header cell inside the table. Clicking a nearby cell outside the table will not activate its table tools.
  2. Choose Table Design on the ribbon.
  3. Read the Table Name field in the Properties group. If you only want to identify the table, do not edit the field.

If you are unsure whether the selected cells belong to a table, look for the contextual tab and the table’s filter arrows or formatting. A formatted range may look like a table but still be an ordinary range; it will not show the Table Design tab when selected. A table created with Insert > Table or Home > Format as Table has a table name.

Find names when a worksheet has several tables

A worksheet can contain more than one Excel table. The Table Name box shows the name of the table containing the active cell, so select a cell in each table to inspect its name. If you click outside a table, the contextual tab disappears; click inside the next table to see that table’s name. The sheet tab at the bottom identifies the worksheet, not the table.

For a small workbook, it is usually quickest to move through the relevant sheets and click inside each visible table. To make the search easier, use the worksheet tabs, scroll through the sheet, and check for filter arrows in header rows. If a table is far below or to the right of the visible area, use the sheet’s scroll bars or the Go To command to reach a known cell, then click in the table.

Excel’s ordinary Find command searches cell contents; it is not a dependable way to search table object names. Pressing Ctrl+F and entering a table name may find matching text in cells, but that does not prove the table itself has that name. Likewise, the formula autocomplete list can suggest table names while you write a structured-reference formula, but it is not a complete workbook inventory.

List every table name in a workbook

Excel does not provide a simple, dedicated worksheet that automatically displays every table name and its location. If the workbook has many sheets or tables, a VBA macro can create a report with each table’s worksheet, name, and cell address. The following example creates a new worksheet called Table List and writes one table per row.

Before running it, save a copy of the workbook. If a sheet named Table List already exists, rename or remove it first, or change the name in the code. The macro adds a new report sheet and does not change the source tables.

Sub ListExcelTables()
    Dim ws As Worksheet
    Dim tbl As ListObject
    Dim report As Worksheet
    Dim nextRow As Long

    ' Add a sheet for the table inventory.
    Set report = ThisWorkbook.Worksheets.Add( _
        After:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count))
    report.Name = "Table List"

    report.Cells(1, 1).Value = "Worksheet"
    report.Cells(1, 2).Value = "Table name"
    report.Cells(1, 3).Value = "Range"
    nextRow = 2

    ' Record each table in the workbook.
    For Each ws In ThisWorkbook.Worksheets
        For Each tbl In ws.ListObjects
            report.Cells(nextRow, 1).Value = ws.Name
            report.Cells(nextRow, 2).Value = tbl.Name
            report.Cells(nextRow, 3).Value = tbl.Range.Address(False, False)
            nextRow = nextRow + 1
        Next tbl
    Next ws

    report.Columns("A:C").AutoFit
End Sub

To use the macro in desktop Excel for Windows, press Alt+F11 to open the Visual Basic Editor, choose Insert > Module, paste the code into the module, and run ListExcelTables. On a Mac, the Visual Basic Editor shortcut can differ by keyboard and Excel settings; use Tools > Macro > Visual Basic Editor if that menu is available. Macros cannot be undone with Ctrl+Z, so keep the backup. Excel for the web cannot create or run VBA macros; open the file in desktop Excel for this method.

Table names, named ranges, and worksheet names

These three terms refer to different things. A table name identifies an Excel table object and is used in structured references. A named range is a name assigned to a cell, range, formula, or constant, and is managed through Excel’s defined-name tools. A worksheet name labels a sheet tab. Changing one does not automatically change the others.

For example, a worksheet named Sales could contain a table named SalesData and a named range called TaxRate. The Table Name box shows SalesData when you select a cell in that table. The worksheet tab still says Sales, while TaxRate is a separate defined name. This distinction matters when you are trying to trace a formula or clean up a workbook: searching Name Manager for a table name is not the same as inspecting the table’s properties.

Tables also have a range of cells, such as A1:C20, but the address is not the table’s name. The range can expand when rows are added, while the table keeps its name unless someone renames it. A table name is unique within the workbook, so two tables on different sheets cannot use the same name.

Rename a table after you find it

If the name is vague, select a cell in the table, open Table Design, and replace the value in Table Name. Press Enter to commit the change. Pick a descriptive name that will still make sense to someone reading the workbook later, such as Orders2026 or ProductList, rather than a generic name like Table3.

Excel table names must follow naming rules. They cannot contain spaces, and they cannot be written as a cell reference such as A1. Use letters, numbers, and underscores to make names readable; for example, use Monthly_Sales instead of Monthly Sales. Names are not case-sensitive for uniqueness, so SalesData and salesdata cannot serve as separate table names.

Renaming a table can affect formulas, charts, or other workbook features that refer to it. Excel generally updates structured references in formulas when the table is renamed, but it is still wise to check key calculations and connected work after a rename—especially in a workbook with external links, queries, or automation. Avoid changing a name merely to make it look nicer if you do not know what depends on it.

Why table names matter in formulas

Excel tables use structured references, which refer to table and column names instead of fixed cell addresses. For instance, a formula can refer to a table column by its header, making the intent easier to understand than a reference to a block such as B2:B500. A table name is the first part of many such references, so knowing it helps when reading or editing formulas.

Suppose a table is named Orders and has a column called Amount. A formula outside the table can use a structured reference such as =SUM(Orders[Amount]) to total that column. The formula uses the table name Orders and the column heading Amount. If you rename the table, Excel can update references in workbook formulas, but typing the old name into a new formula will not be correct after the change.

Table names also make formulas more adaptable as tables grow. A structured reference to a table column normally includes the column’s data, including new rows added to the table, rather than relying on a fixed range endpoint. This is one reason a table name is worth checking before copying a formula from another workbook or troubleshooting a formula that returns an error.

Common problems when looking for a name

  • The Table Design tab is missing: Click inside the table itself. If the tab still does not appear, the cells may be a normal range with formatting rather than an Excel table.
  • The name seems to belong to the wrong table: Check which cell is active. The name shown belongs to the table containing that cell, not necessarily the table you were looking at a moment earlier.
  • Ctrl+F finds the name in a cell: That result is matching text, not necessarily the table object. Confirm by selecting the table and checking the Table Name box.
  • A name is not accepted in a formula: Check spelling and whether the table still has that name. Also check the column heading inside the structured reference; table names and column names are separate parts.
  • You cannot find a table on a sheet: It may be outside the visible area, on a hidden worksheet, or the cells you expected to be a table may only be formatted. The VBA inventory can help identify tables on worksheets, including hidden ones.

Windows, Mac, and Excel for the web

The basic method is similar in current desktop versions of Excel: select a table cell and look for the table’s contextual design tab and name field. On Windows with Microsoft 365, that tab is called Table Design. Excel for Mac also provides table design tools after a table is selected, although the ribbon layout and keyboard shortcuts can differ. If the tab is not visible, first confirm that the active cell is inside a table.

Excel for the web supports working with tables, but its ribbon may present table tools differently from the Windows desktop ribbon. Select a cell in the table and look for its table-related tab or properties. If the name field is not available in your browser interface, open the workbook in desktop Excel to inspect or change it. VBA is a desktop feature and does not run in Excel for the web.

Frequently Asked Questions

How do I see the name of an Excel table?
Click a cell inside the table, then check the Table Name box on the Table Design tab. The box shows the name of the selected table.

Can I use Ctrl+F to search for an Excel table name?
Ctrl+F searches worksheet content, not table object names as a reliable workbook-wide search. Select the table and inspect its Table Name field, or create a VBA inventory if you need to check many tables.

Are table names shown in Name Manager?
Name Manager is for defined names, such as named ranges. To check an Excel table’s name, select the table and use the Table Name box on Table Design.

How can I find all table names in a workbook?
For a few tables, inspect them one at a time by selecting a cell in each. For a larger workbook, use a VBA macro to write table names and locations to a report sheet; macros do not run in Excel for the web.

Can I rename an Excel table?
Yes. Select a cell in the table, edit the Table Name field on Table Design, and press Enter. Use a name without spaces and check important formulas or workbook connections afterward.

Why is Table Design not appearing?
The selected cell may be outside the table, or the range may only be formatted to look like one. Click inside the actual table; if the tab still does not appear, create a table from the range using Insert > Table if that is what you need.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.