Every time that you create an Excel table, Excel assigns a default name to the 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.
- Click the table that you want to rename.
- On the Tables tab, under Tools, click Rename.
- On the formula bar, in the Name box (Name box: The box at the left end of the formula bar that identifies the selected cell, chart item, table name, or drawing object. You can type a name in the Name box, and then press ENTER to quickly name a selected cell or range. You can also move to and select a previously named cell by clicking its name on the Name pop-up menu.), type a new table name.
- Press ENTER .
Create or delete an Excel table
Format an Excel table