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.

  1. Click the cell containing the formula.

  2. 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.

  3. 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