After you’ve entered a formula, you can (of course) edit that formula. You may need to edit a formula if you make some changes to your worksheet and then have to adjust the formula to accommodate the changes. Or the formula may return an error value, in which case you edit the formula to correct the error.
The following are some of the ways to get into cell edit mode:
Tip
You can control whether Excel displays error indicators in the Formulas section of the Excel Options dialog box. To display this dialog box, select Office Button Excel Options. Click Formulas. If you remove the check mark from Enable Background Error Checking, Excel no longer displays the error indicators or the Error Checking button.
While you’re editing a formula, you can select multiple characters either by dragging the mouse cursor over them or by pressing Shift while you use the direction keys.
Tip
If you have a formula that you can’t seem to edit correctly, you can convert the formula to text and tackle it again later. To convert a formula to text, just remove the initial equal sign (=). When you’re ready to try again, type the initial equal sign to convert the cell contents back into a formula.