Naming Excel tables can help make formulas easy to read

Are you an expert at using Excel Tabels to Group, filter, and total large lists of data? If so, then you know all the benefits tables can bring to your Excel workbook and how much time they can save you. However, did you know you can name them?

For years, I used tables in my spreadsheets — a lot of them — as part of my day-to-day routine. But, I didn't realize that taking a few seconds to give them names could help me keep track of, and keep clear about, which was which when creating formulas. The names become part of formulas you create, so reading a formula to access some information in a table is almost like reading english ... almost.

Naming a Table

Click anywhere in the body of your Excel table, which will cause the Table Tools ribbon to appear. It contains just a single tab, Design. On the Design tab, in the Table Name box at the far left, see the table name. It's probably something basic like Table1. Type a new name in the box and press Enter.

The Design tab, showing a table with a default name

Table names must start with a letter or underscore, they can't contain spaces or special characters, and they can't have names that are already used in Excel elsewhere. For example, you can't use "Sheet 1" if you already have something in your workbook with that name.

The Design tab, showing a named table

Referring to a Named Table

A named table uses column headers instead of cell references when building formulas referring to other named tables

Now, when you build a formula, you can enter the table name in place of any cell range. In Function Arguments screenshot, $A$1:$0$104 is replaced by Client_Hours.