When you create Excel tables, Microsoft Office Excel assigns a default name to each table by using the following naming convention: Table1, Table2, and so on. However, you can change the name of each table to make it more meaningful to you.
- In the worksheet, click the table that you want to rename.
This displays the Table Tools, adding the Design tab.
- On the Design tab, in the Properties group, click the Table Name text box.
- Type a new name.
- Press ENTER.