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.

  2. On the Design tab, in the Properties group, click the Table Name text box.

  3. Type a new name.

  4. Press ENTER.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language