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.
Sylvie from France commented
Great idea! I use a macro to do that. The macro gets the name if the table via an inputBox, adds the prefix, and gives the same name to tje worksheet.
It does other actions that I used to do every time: freeze the first row, center all cells vertically, makes the first row bigger to have space for slicers, align bottom and center horizontally the first row, add a column "visible" with a simple formula returning 0 if the row is hidden (filtered out) or 1 if visible... The Visible column is usefull in all XxxIFS formulas. SUMIFS(...., tblDemo[Visible],1)
Tom Wright commented
I came on to submit the same idea; I'm tired of meaningless names, you should be prompted to provide a name each time. Creating a table and naming it simultaneously should be the way this works; even for people who don't max out on tables would benefit from cleaner workbooks with proper references.
Tom Summers commented
I just wanted to submit this idea. Great that it's already out there and has received some votes!
Ajay Anand commented
It would be very helpful if the Create Table dialog has the option to name the Table.
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.