Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel Table headers - field names list not showing when typing

Copper Contributor

Hello,

 

Excel automatically creates table names, i.e. Table1, Table2 etc.. If I start typing ="Table1[..", the list of field names automatically pops up after the square brace '[' and I can just select the field I require in a formula.

 

After I rename 'Table1' to a meaning table name, i.e. myTable the list of field names does not automatically show when I start typing "=myTable[.." 

 

 

5 Replies

@lkwan2180 

On which Excel platform/version you are? In general it works

image.png

So how did you 'rename' the table? you must click on the table and go to the Table Design tab in the menu and then click in the table name there. IF you highlighted the table and change the RANGE name you defined a RANGE that matches the table area but that is not a new TABLE name. You can check by typing Table1[ and see if the columns come up because excel still thinks that table is named Table1

Here is an image of the Table Design menu with the Table Name box on the left.

mtarler_0-1698155569034.png

Alternatively you can also 'rename' the table using the Name Manager (Formulas Tab):

mtarler_1-1698155806399.png

 

In the above image is the Name Manager where I renamed Table1 to Table1b but myTable is a range not the Table name (notice how it refers to =Table1b(#All) since the Table name is Table1b and was not changed to myTable)

If this is not the issue, please share a sample sheet we can check more into.

@Sergei Baklan 

 

Thanks for the reply.  I solved the problem.

 

It seems Excel does not like periods "." anywhere in the name.  So if I had a table named "tbl.Table1" I do not see the field names when I type.  

 

However, if I take out the period and rename it "tblTable1" and everything works. 

@lkwan2180 

That's definitely a bug. You may use underscore, tbl_Table1, field names are shown with it.

If we speak about desktop version, period works in Excel for web

image.png