How-To Geek's Tony Phillips describes the old problem plainly. You had to create the table first, then open the Table Design tab to change its name. In his words, when you're focused on getting your data into a workbook, it's easy to put off that extra step until later—or forget it altogether. Now Microsoft is adding a table name field to the Create Table dialog: you can now give the table a meaningful name as you create it.
What changed in the Create Table dialog
For a long time, this dialog asked only two things: which range to use and whether the data has headers. Excel Campus reports that when you insert a table using Format as Table, the Insert tab's Table button, or the Ctrl+T shortcut, the Create Table dialog now shows a second field: "What is the name of your table?" It defaults to Table1, but you can replace it with anything descriptive before you click OK.
Excel Campus calls it an update "19 years in the making." That's a bit of an exaggeration, but the point stands: the dialog's core layout had gone without this field for a very long time.
Summary: The name field shows up wherever the Create Table dialog appears, including the ribbon commands and the Ctrl+T shortcut. If you ignore it, you get the same default Table1-style name as before.
Who has it right now?
Availability is the main thing to understand before you look for the field.
- How-To Geek says Microsoft is rolling the feature out gradually, so it may or may not be in your version of Excel.
- Trainer Chris Menard reported that this feature is currently rolling out on the Beta Channel as of August 30, 2026.
- Exceljet's tables guide says that as of September 2026, the Create Table dialog in the Excel 365 Beta Channel also includes a field for the table name, and warns that this feature may not be available in your version of Excel yet.
- A HubSite 365 summary notes that availability depends on the Excel version, platform, and Insider release ring.
One more thing to keep in mind: Microsoft's own support article on creating and formatting tables still describes the old two-field dialog (range and header checkbox). It doesn't mention the new name field yet. Microsoft also hasn't published which channels or platforms (Windows, Mac or web) have the feature, or when it will reach Current Channel. If you're on Current Channel or Monthly Enterprise Channel and don't see it, nothing is wrong with your install. It just hasn't arrived for you yet.
How to name a table as you create it
If you have the new field:
- Select a cell in your data, or the whole range.
- Go to Insert > Table, use Home > Format as Table, or press Ctrl+T.
- In the Create Table dialog, check that Excel picked the right range.
- Type a descriptive name in the new name field.
- Make sure My table has headers matches your data.
- Click OK.
To do it from the keyboard, How-To Geek's steps are: press Ctrl+T, use Tab to reach the name field, and enter the name. If the headers checkbox needs changing, press Tab again and toggle it with Space. When you're done, press Enter. Excel Campus adds that after the Tab, focus jumps straight to the name field with the default text already selected, so you can start typing your table name immediately.
If you see a name field: you're on a build with the feature, and the table will be created with your name already applied.
If you don't: use the old method, which works everywhere:
- Click any cell in the table so the Table Design tab appears. On some versions it's labelled Table.
- Click the Table Name box at the far left of the ribbon.
- Type the new name and press Enter.
Excel Campus lists Alt, J, T, A as the keyboard sequence for that Table Name box.
Naming rules
The name field doesn't change the rules for what counts as a valid name. A rejected name is the most likely error you'll hit. Microsoft's guidance on structured references sets out the rules:
| Rule | What it means in practice |
|---|---|
| Valid first character | Start with a letter, an underscore (_), or a backslash () |
| Remaining characters | Letters, numbers, periods and underscores only |
| No spaces | Use Sales_Tax or First.Quarter instead |
| No cell-reference lookalikes | Names like Z$100 or R1C1 are rejected |
| Reserved single letters | "C", "c", "R" and "r" aren't allowed |
| Length | Up to 255 characters |
| Unique per workbook | Matching ignores case, so "Sales" and "SALES" conflict |
How-To Geek's example of a forbidden name, BIN9, comes from Microsoft's general guidance on defined names. The table-specific documentation uses Z$100 and R1C1. The idea is the same either way: if Excel could read the name as a cell address, it won't accept it. Watch out for short prefix-plus-number names like "Q1" or "tbl1". Q1 is a real cell, so Excel rejects it, while "tbl1" is fine because no column in Excel goes as far as TBL.
Summary: Most rejected names involve a space, a leading digit, or something that looks like a cell address.
Why table names are worth the effort
This isn't just about tidiness. A good name pays off in several places.
Formulas you can read. Compare =SUM(tblSales[Profit]) with a formula that points at Table7. The first one tells you what it adds up. Microsoft's documentation adds that structured references adjust automatically as rows are added or removed, so a named table is both readable and dynamic.
Navigation. The Name Box dropdown lists every table in the workbook. Descriptive names turn it into a quick way to jump between sheets, and a shared prefix keeps all your tables grouped together in the list.
Power Query and the Data Model. Excel Campus points out that a query built from a table takes the table's name, so naming the table first gives you a sensibly named query from the start. It also warns that renaming a table after other things depend on it can break Power Query connections or links from other workbooks. Microsoft's guidance on Data Model relationships also tells users to give each table a meaningful name before creating relationships. A name won't create a relationship for you, but it makes it much easier to pick the right table from the list.
Copilot context. Menard argues that a prompt like "update the Vendor_Purchases table" is clearer to Copilot than "update Table4". That's his view as a trainer, not something Microsoft has benchmarked, but it makes sense.
Naming conventions and a Quick Access Toolbar tip
Prefixes are optional. Microsoft's support guidance suggests prefixes by object type, such as tbl_Sales for a table and ptSales for a PivotTable. How-To Geek prefers tblSalesData-style UpperCamelCase or a T prefix. Both camps agree that the specific style matters less than using the same one every time. Keep names short, too: tblSales is easier to type than a name that tries to describe the whole quarter.
If you want to see table names without opening the ribbon, How-To Geek has a separate tip: right-click the Table Name text on the left and select Add to Quick Access Toolbar. After that, whenever you click inside a table, its name appears in the QAT, where you can also edit it.
Our take
It would be easy to dismiss this as a minor UI change, and on its own it is minor. But it removes the step people most often skip. Good practice that depends on going back later tends not to happen. When the name box sits right in the dialog, naming the table becomes the normal path.
There are limits. The default Table1 is still pre-filled, so anyone in a hurry can press Enter and skip it, just as before. The field also does nothing for workbooks you already have full of generic names. For those, Excel Campus suggests asking Copilot (or the ChatGPT or Claude add-ins) to rename every table in one go. If you try that, check what it did, especially if formulas in other workbooks or Power Query connections point at the old names.
Bottom line: If you're on the Beta Channel, try Ctrl+T and then Tab today. If you're not, the Table Design name box works fine until the feature reaches you, and naming your tables is still worth doing either way.
References
- I've always recommended naming Excel tables, and Microsoft just removed the annoying part How-To Geek · 2026-10-25T17:31:17+00:00
- Create and format tables | Microsoft Support support.microsoft.com
- Excel Tables exceljet.net