How to Name an Excel Table
Naming a table in Excel simply makes sense. A name can also provide a quick description of what the table describes. It is also easier to remember a table by a familiar name than simply trying to remember a generic table name like “Table1”. To name a table in Excel simply follow the steps below.
Step 1: Select a cell within your table.
Step 2: Click on the Design tab and locate the Properties group in the Design ribbon.
Step 3: In the Table Name box replace the generic table name (for example Table1) with the name you want to give to your Excel table and press ENTER.
You may get an error box if you entered a table name that is invalid. Table names must start with either a letter or an underscore, they cannot contain a space and cannot be the same name as a range of cells or a name that will conflict with other names that Excel already has built in.