Editing a formula
You edit a formula in a cell the same as you edit any cell entry. Building your spreadsheet provides basic information about entering and editing data. Entering a formula provides all the basic information for entering formulas in your worksheet, and More power with formulas describes all the basic parts of a formula and the different types of formulas.
- Click the cell containing the formula.
- Press F2 and edit the formula directly in the cell or click the contents box at the top of the worksheet and edit the formula there.
- When you are finished editing the formula, press ENTER.
See also
More power with @functions
When and how formulas recalculate
Controlling how a formula refers to data
Fixing common errors in formulas
Entering a range address in a formula
Entering a range name in a formula
Copying a formula
Moving a formula