Microsoft Office Tutorials and References

In Depth Information

**Using formulas within a table**

5.
Press Enter to end the formula.

The formula is entered into the other cells in the column, and the Formula bar displays this

formula:

=[@Actual]-[@Projected]

Figure 75-3 shows the table with the new column.

Figure 75-3:
The Difference column contains a formula.

Although the formula was entered into the first row of the table, that’s not necessary. Anytime a

formula is entered into an empty table column, it propagates to the other cells in the column. If you

need to edit the formula, edit any formula in the column, and the change is applied to the other cells

in the column.

Propagating a formula to other cells in a table column is actually one of Excel’s

AutoCorrect options. To turn off this feature, click the icon that appears when you enter

a formula and choose Stop Automatically Creating Calculated Columns.

Note

The preceding set of steps uses the column names to create the formula. Alternatively, you can enter

the formula by using standard cell references. For example, you can enter the following formula in

cell E3:

=D3-C3

If you type the cell references, Excel still automatically copies the formula to other cells in the column.