Updating Excel Formulas
When you use cell references in Excel formulas, the formulas will automatically update whenever the relevent data in the spreadsheet changes.
For example, if you realize that the data in cell A1 should have been an 8 instead of a 3, you only need to change the contents of cell A1.
Excel updates the answer in cell C1. The formula, itself, doesn't need to change because it was written using cell references.
Changing the data
- Click on the cell A1
- Type an 8
- Press the ENTER key on the keyboard
The answer in cell C1 where the formula is, immediately changes from 5 to 10, but the formula itself is unchanged.