When using Excel and I insert a table in Spreadsheets I am used to renaming the table to something useful so I know what columns or fields in which table my formulas use. Is have not found a setting for this, and it does not seem to be in the Table settings either.
Is there a way to rename a table from the default Table1 to something else, or is this not (yet) supported?
Hello @Mike
Please refer to the guide: Spreadsheet Editor - Manage sheets
To rename an existing sheet:
- right-click the sheet tab you wish to rename,
- select the Rename option from the right-click menu,
- enter the Sheet Name in the dialog box and click OK.
The selected sheet name will be changed.
Hello @Constantine
Thank you for your answer.
I think I was not clear enough with my problem description. I do not want to rename a sheet, but a table I inserted into the sheet. The ones you get via the Tab Insert > Table, which then have alternating row colors, unique column headings and other formatting options and features.
One of the features I use is the column referencing in formulas:
=Table1[@End]-Table1[@Start]
This takes the End and the Start value of the columns in the same row as the field with the formula form the table Table1.
Table1 is the name of the table i inserted, Excel allows to rename those, which makes sense when you are working with lots of tables and formulas. These table names seem to represent namespaces which then can be used in the whole file without referencing sheet names.
Any idea how to rename this Table1?
Or is this not (yet) possible?
I had another look in the documentation. These are the tables I am talking about:
The last section about formula autocomplete references the table name I want to change.