Microsoft Office Tutorials and References

In Depth Information

**Working with Tables**

This workbook, named
table formulas.xlsx
, is available on the companion

CD-ROM.

1.
Activate cell E2 and type
Difference
for the column header.

Excel automatically expands the table to include a new column.

2.
Move to cell E3 and type an equal sign to signify the beginning of a formula.

3.
Press
←
, and Excel displays =[@Actual], which is the column heading in the Formula bar.

4.
Type a minus sign and then press
←
twice. Excel displays =[@Actual]–[@Projected] in

your formula.

5.
Press Enter to end the formula.

Excel copies the formula to all rows in the table.

Figure 9-12 shows the table with the new column.

Figure 9-12:
The Difference column contains a formula.

If you examine the table, you’ll find this formula for all cells in the Difference column:

=[@Actual]–[@Projected]

The “at” symbol (@) that precedes the column header represents “this row” (the row

that contains the formula).

Keep in mind that I didn’t define any names in this worksheet. The formula uses table references

that are based on the column names. If you change the text in a column header, any formulas

that refer to that data update automatically.