Excel now lets you name a table when you create it. What to call it so nothing breaks later

Can you name a table when you create it in Excel now?

Microsoft first showed this to Office Insiders in What’s New in Excel for September 2026. They explain that the Create Table dialog now lets you give tables meaningful names at the exact moment you create them. You just press Ctrl+T or go to Insert, click Table, type a name, and create the table.

The October 2026 edition was posted on 27 October, and it says the feature is now available to Excel for Windows and Excel for Mac users. Excel for the web is missing from that list. If you use Windows or Mac and you do not see the box yet, you should check for Office updates, because these features usually roll out to people in waves.

I have not received the new box on my own copy of Excel yet, so the steps below follow Microsoft’s description. The naming rules and the rename behaviour I explain next come directly from Microsoft’s support pages, and they have not changed with this update.

Why does an Excel table name matter?

When a formula points at a table, Excel writes a structured reference. A structured reference is just the table name followed by the column name in square brackets. Microsoft uses the example of =SUM(DeptSales[Sales Amount]) in place of =SUM(C2:C7). This reference grows along with the table, so Excel counts a new row without you having to touch the formula.

The table name is the part of that reference that tells you exactly where the data lives. A default name leaves the formula correct but very hard to read. A real name makes the formula read almost like a normal sentence, so anyone opening the file next year can check it without hunting around.

A good name also helps outside of your formulas. Every table shows up in the Name Box to the left of the formula bar, and clicking one jumps you straight to it, even if it is on another sheet. A list showing tblOrders, tblCustomers and tblReturns acts as a map of your workbook. A list of Table1 to Table9 does not help you at all.

This matters for AI tools too. When you ask Copilot or a colleague to work on “the orders table”, an actual table named tblOrders leaves no doubt about what you mean. If you use Copilot inside a workbook, I explain how to stop it from changing things before you have checked them in using Copilot in Excel in chat only mode.

What breaks when you rename an Excel table later?

Nothing breaks inside the workbook. Microsoft’s page on using structured references with Excel tables explains that when you rename a table or a column, Excel updates every structured reference to it in that workbook. So a late rename is perfectly safe if formulas are the only thing using the table.

The trouble comes from anything that stored the name as plain text. Excel’s formula engine does not read that text, so it cannot go in and rewrite it. Power Query is the most common example of this. A query built from a table in the same workbook starts with a step like the one below, and the old name just sits inside it in quotes.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    ...

If you rename Table1 to tblOrders, that step still asks for Table1. The query cannot find the table on the next refresh and stops with an error, so every report built on that query breaks down with it. The exact same thing happens to a VBA macro that says ListObjects("Table1"), to an Office Script calling getTable("Table1"), and to an INDIRECT formula that builds the reference out of text.

Tools outside the file are the last group to watch out for. If a Power Automate flow reads rows from your table, as I showed in my guide to refreshing Excel and Power Query with Power Automate, you need to open the flow after any rename and check that its table field still shows the right table. A broken connection usually fails at night and only shows up when someone asks why the morning report is empty.

What is a good name for an Excel table?

Microsoft’s page Rename an Excel table sets out the hard rules. A name must begin with a letter, an underscore or a backslash, and the rest can only be letters, numbers, periods and underscores. Spaces are banned, the name can be up to 255 characters, and it must be unique in your workbook. Excel ignores upper and lower case, so Sales and SALES count as the exact same name.

Two specific rules often catch people out. You cannot use C, c, R or r on their own, because Excel reserves them as shortcuts for the current column and row. Also, a name cannot look like a cell address. This rule is sneaky because Excel’s columns go all the way to XFD and its rows go to 1,048,576, so plenty of normal words are actually real cells.

For example, FY24 is the cell in column FY, row 24, and Tax2026 is the cell in column TAX, row 2026. Excel will refuse both names. A short prefix fixes this problem completely, which is why many people start table names with tbl. That prefix also groups every table together when you scroll through the Name Box or the list in Power Query.

Beyond those strict rules, I use my own naming convention. It is just a habit rather than a fixed standard, so any consistent pattern you like will work just as well.

The fourth habit saves me the most trouble. A table called tblSales2026 that keeps taking in 2027 rows will either carry a wrong name for years or need a rename eventually. You already know what a rename does to the queries that depend on it.

How do you name a table when you create it?

This matches Microsoft’s description of the new dialog. The only new part is the name box, and the rest is the same Create Table window you already know.

1. 01
   Click one cell inside your data

   Excel guesses the range from the cell you are on, so make sure the data has a single header row and no fully blank rows in the middle.
2. 02
   Press Ctrl+T, or go to Insert and then Table

   The Create Table dialog opens with the range it guessed. Check the range and tick My table has headers if the first row holds column names.
3. 03
   Type the name in the new name box

   Use the habits above, for example tblOrders. If you leave the box alone you get the old default name, Table1, Table2 and so on.
4. 04
   Click OK and check the Table Design tab

   The Table Name box on the far left of that tab should show your name. That box is also where you rename a table later, and on older versions it is still the only place.

If your data needs cleaning first, you should do that before you make the table. Stray spaces in headers and merged cells cause a lot more trouble than a bad name. My guide to cleaning messy Excel data covers that exact process.

Should you rename the Table1 tables you already have?

That depends on what uses those tables. You can rename a table today if it is only used by formulas in the same workbook. Excel updates every reference for you, so you lose nothing.

If a query, a macro, a script or a flow reads the table, you should rename it only when you have time to fix those in the same sitting. A good way to check is to open Data, then Queries and Connections, and look at each query’s first step for the table’s current name. You can then search the VBA editor using Ctrl+F for the same name in quotes.

For tables you make from now on, this problem goes away entirely. A table named on day one never needs to be checked later. That is also the right time to decide how the table should grow. In my piece on formulas that miss new rows I explain why a real table is the safest home for data that gets new rows every day.