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
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:
If you type the cell references, Excel still automatically copies the formula to other cells in the