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

in Guides by (552k points)
reopened | 108 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.



by (3.5m points)
edited

Related questions

+5 votes
1 answer
asked Apr 18, 2023 in Guides by backtothefuture (552k points) | 65 views
+4 votes
1 answer
asked Feb 24, 2022 in Guides by backtothefuture (552k points) | 86 views
+4 votes
1 answer
asked Jan 9, 2022 in Guides by backtothefuture (552k points) | 109 views
+4 votes
1 answer
asked Dec 30, 2021 in Guides by backtothefuture (552k points) | 134 views
+4 votes
1 answer
asked Dec 23, 2021 in Guides by backtothefuture (552k points) | 94 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users