Microsoft Office Tutorials and References

In Depth Information

**Using formulas within a table**

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

this formula:

=[@Actual]-[@Projected]

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

Figure 160-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.

The preceding set of steps used 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.