One of the best features of tables is called “calculated columns”.
Calculated columns help you enter and maintain formulas in Excel tables.
A quick way to copy down the formula is to double-click thefill handle.
Since every cell has a price, Excel copies the formula to the bottom.
Next, I’ll add a formula to calculate a 7% tax.
Again, I can double-poke the fill handle to copy it down.
At this point, the first formula is out of sync with the rest.
To confirm all formulas are consistent, I need to copy the formula down again.
Now let’s look at the same formulas in an Excel table on the next sheet.
When I enter the Total formula, the formula automatically fills the entire column.
There is no need to copy it down.
The same is true of the Tax formula.
After I hit Enter, the formula is copied to the bottom of the column.
That’s how calculated columns work.
Notice the autocorrect icon appears when using calculated columns.
you might use this menu to navigate directly to Excel’s autocorrect options.
If you do this, you’ll see your change revert to a local change.
This works somewhat like calculated columns but with a manual trigger.
To re-enable fill formulas, you’ll need to visit the Auto Format options in the Proofing area.
