If you’re like most people, you probably use Microsoft Excel to keep track of your finances. And if you’re like most people, you probably have a lot of tables in your workbook. But how do you name a table? Well, it depends on what kind of table it is. Here’s a guide to naming different kinds of tables in Microsoft Excel: Table Name Description Example Sheet1 Your first sheet in the workbook. “Sheet1” Sheet2 Your second sheet in the workbook. “Sheet2” Table1 A table that contains data from one or more sheets. “Table1” Table2 A table that contains data from one or more sheets and is used as a reference for other tables. “Table2” Chart1 A chart that uses data from Table1 as its source. “Chart1” Chart2 A chart that uses data from Table2 as its source. “Chart2” If you’re not sure what kind of table you have, just look at the name of the sheet where the table is located: If the table is on Sheet1, the name will be something like “Sheet1_TableName”. If the table is on another sheet, the name will be something like “SheetName_TableName”. ..
By default, Microsoft Excel names your tables “Table1”, “Table2”, and so on. If you’d prefer custom names, you can rename your tables in Excel. It’s 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 table’s name must start with a character, an underscore (_), or a backslash (). Also, you can’t use “C”, “c”, “R”, or “R” as your table name as these characters are designated for other purposes in Excel. Cell Reference: You can’t use a cell reference as your table name. Name Separator: You can’t 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 can’t have two tables with the same name in your workbook. Also, Excel considers uppercase and lowercase table names the same, so you can’t 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.
In your spreadsheet, click any cell of the table you want to rename.
While your cell is selected, in Excel’s ribbon at the top, click the “Table Design” tab. If you are on a Mac, click “Table” instead.
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.
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 you’re all set.
Need to add or remove rows or columns from your Excel table? It’s equally easy to do that.
RELATED: How to Add or Delete Columns and Rows in a Table in Microsoft Excel
