Most valuable professional
  • Excel Book Excerpt

Excel Rename Your Tables

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Rename Your Tables

Problem: Is a formula such as =SUM(Table1[Revenue]) supposed to be meaningful?

Strategy: When you create a table by pressing Ctrl+T, Excel gives the table a generic name, such as Table1, Table2, and so on. If you rename the table, the formulas will start to make more sense. Here’s what you do:

1. Convert a range to a table by selecting one cell in the range and pressing Ctrl+T and clicking OK.

2. Click in the Table Name field in the Properties group in the Design ribbon and type a new name for the table. A name such as
SalesData might be more meaningful than Table1.

Results: Excel will rewrite any formulas that point to the table to use the new table name. For example, it will change the =SUM(Table1[Revenue]) you asked about to =SUM(SalesData[Revenue]).

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: