+5 votes
2 views
How to name a table in Microsoft Excel

ago in Guides by (473k points)
reopened ago | 2 views

1 Answer

+3 votes
Best answer

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

image

Once we are in the spreadsheet, what we will do is click on any cell in the table that we want to rename..

image

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".

image

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.



ago by (3m points)
edited ago

Related questions

+4 votes
1 answer
asked Dec 30, 2021 in Guides by backtothefuture (473k points) | 7 views
+4 votes
1 answer
asked Dec 23, 2021 in Guides by backtothefuture (473k points) | 4 views
+4 votes
1 answer
asked Nov 18, 2021 in Guides by backtothefuture (473k points) | 5 views
+4 votes
1 answer
asked 2 days ago in Guides by backtothefuture (473k points) | 3 views
+3 votes
1 answer
asked 4 days ago in Guides by backtothefuture (473k points) | 3 views
9,075 questions
9,178 answers
416 comments
2 users