Supported names Name a table in Excel
By default, Excel names tables "Table1", "Table2", and so on. However, it is possible to name a table in Microsoft Excel whatever we want. In a really very simple way we can customize the names of all the tables that we are using in the office automation program..
A little further down, we are going to see a detailed guide so that in a few minutes you are very clear how easy it is to name any table in our Microsoft Excel spreadsheet.
Supported names
- Leading character: the table name must start with a character, underscore (_), or backslash (\). It is also not possible to use C, c, R or as the only name of your table, this is because these characters are designated for other purposes in Excel.
- Cell Reference: It is also not possible to use a cell reference as the name of your table.
- Name separator: You cannot separate multiple words in your table name with a space. In order to do this, we must use an underscore or period.
- Character limit: maximum characters is 255.
- Names cannot be repeated: it is not possible to have two tables with the same name. We must consider that the names in lowercase and uppercase are the same. Therefore, we cannot use "mytable" if we already use "MYTABLE".
Name a table in Excel
Once we are in the spreadsheet, what we will do is click on any cell in the table that we want to rename..
With the cell selected, we are going to have to click on the Excel ribbon at the top and select "Table Design". For Mac users it is "Table".
In the tab "Table design" we will have to go to the "Properties" section and click on the "Table name" field. After this we are going to write a new name for the table and press "Enter"..
From now on, the table will have this specific name. We can do this with all the tables we have in Excel.