After you create a formula, you can always edit it later. You can edit a formula in two places:
In the Formula bar In the cell itself
To edit a formula in the Formula bar, follow these steps:
1. Select the cell that contains the formula you want to edit.
Excel displays the formula in the Formula bar.
2. Click in the Formula bar and edit your formula using the Backspace and Delete keys.
To edit a formula in the cell itself, follow these steps:
1. Double-click in the cell that contains the formula you want to edit.
Excel displays a cursor in the cell you selected.
2. Edit your formula using the Backspace and Delete keys.
Because formulas display their calculations in a cell, it can be hard to tell the difference between cells that contain numbers and cells that contain formulas. To make formulas visible, press Ctrl+V (an accent grave character, which appears on the same key as the ~ symbol).