Change Excel Table Name in the Create Table Window
Every time I Insert an Excel Table I then have to go change the Table Name (Alt+J,T,A). It would be great if the Table Name could be changed on the Create Table window when you are selecting the range of the Table.
It would also be nice to have some default settings for the table names. For example, I prefix all my table names with "tbl". This makes it a lot easier to get a list of the tables in the workbook when writing formulas. I would like to store this preference somewhere and then have the table name be prefixed with "tbl" when the table is created.
I would also like the initial table name to be more intuitive. It could default to the header name of the first column in the table, instead of Table1. Of course this wouldn't work every time, but it would be a lot more descriptive than Table1.
Randy Rhea commented
Great idea Jon!
A great idea hope it gets approval
Not a major for MS , should be able to fix doing a update !
Antony Pihut commented
It would be nice to add to the same pop-up window "Create Table" a field "Table Name:" with a pre-populated "Table1" that offers to name the table as you create it.
David Uyarra commented
Really good idea, I subscribe it.
Heather R commented
GREAT idea - and yes, I'm still using "tbl_" as a prefix in building tables. The ability to have a default prefix would be nice, but at the very least let me name the table when I build it.
Neale Blackwood commented
Tables are such an important part of Excel now that making the naming process easier and quicker is a great help.
Jørgen Koch commented
Generally I do the same for basic solutions and when teaching the use of tables but when building more advanced solutions I use f as prefix for fact tables and d for dimension tables.
I furthermore use qry as prefix for power queries – or only q in more advanced solutions.
I use the same name convention for pivot tables – i.e. pvtSales for the pivoted tlbSales data table, so it could be a good idea to be able to name the pivot table when creating it.
Wyn Hopkins commented
Oz du Soleil commented
I agree with this. It would be such a help to be able to name a table when creating the table.