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