Rename an Excel table

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.

  1. In the worksheet, click the table that you want to rename.

This displays the Table Tools, adding the Design tab.

  1. On the Design tab, in the Properties group, click the Table Name text box.
  2. Type a new name.
  3. Press ENTER.
 
 
Applies to:
Excel 2007