Excel: Rename Your Tables

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

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 tSalesData 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]).