How to find a table in Excel by name

How to Name a Table in Microsoft Excel Mahesh Makvana @maheshhari December 22, 2021, 1:00pm EDT By default, Microsoft Excel names your tables Table1, Table2, and so on.

How to find a table in Excel by name

How to Name a Table in Microsoft Excel

  • Mahesh Makvana

@maheshhari

  • December 22, 2021, 1:00pm EDT
Microsoft Excel logo on a green background

By default, Microsoft Excel names your tables Table1, Table2, and so on. If youd prefer custom names, you can rename your tables in Excel. Its easy, and it works similarly to assigning names to cell ranges.

RELATED: How to Assign a Name to a Range of Cells in Excel

Supported Table Names in Microsoft Excel

Excel has certain rules for naming tables, and you must adhere to these while giving names to your tables:

  • Starting Character: Your tables name must start with a character, an underscore (_), or a backslash (\). Also, you cant use C, c, R, or R as your table name as these characters are designated for other purposes in Excel.
  • Cell Reference: You cant use a cell reference as your table name.
  • Name Separator: You cant separate multiple words in your table name with a space. To do that, use either an underscore or a dot.
  • Character Limit: Your table name must fit the 255 maximum character limit.
  • No Same Names: You cant have two tables with the same name in your workbook. Also, Excel considers uppercase and lowercase table names the same, so you cant use MYTABLE if you have used mytable in your workbook already.

When you rename your table and you miss one of the above points, Excel will alert you with an error message so you can fix the issue.

RELATED: How to Highlight Blanks or Errors in Microsoft Excel

How to Rename a Table in Microsoft Excel

To give a name to your table, first, open your spreadsheet with Microsoft Excel.Advertisement

In your spreadsheet, click any cell of the table you want to rename.

Click a cell in a table in Excel.

While your cell is selected, in Excels ribbon at the top, click the Table Design tab. If you are on a Mac, click Table instead.

The Best Tech Newsletter Anywhere

Join 425,000 subscribers and get a daily digest of features, articles, news, and trivia. Sign Me Up! We've got your info - thanks for signing up! We were unable to subscribe you! Please check your e-mail address or contact us for assistance. Signing you up...

By submitting your email, you agree to the Terms of Use and Privacy Policy.

Click the "Table Design" tab in Excel.

On the Table Design tab, in the Properties section, click the Table Name field. Then type a new name for your table and press Enter.

Click the "Table Name" field and type a name for the table.

Advertisement

Your table now uses your specified name, and this is the name you will use to refer to it from other cells in your spreadsheet.

And youre all set.


Need to add or remove rows or columns from your Excel table? Its equally easy to do that.

RELATED: How to Add or Delete Columns and Rows in a Table in Microsoft Excel

Mahesh Makvana

Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. Hes written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips. Read Full Bio »

Video liên quan