Microsoft Office Tutorials and References
In Depth Information
Working with Tables
This workbook, named table formulas.xlsx , is available on the companion
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
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:
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.