To view the formulas that are
contained in your worksheet, press CTRL and
` (CTRL and the
apostrophe key to the left of the number 1 at the top of your keyboard)
together. Repeat to hide the formulas and show the values.
Alternatively, you can click on the Tools drop-down menu, choose Options,
click on the View tab at the top of the window and click to place a tick
beside the word Formulas in the Window options section. To edit a formula you need to click in the cell containing the formula
and then use the formula bar to amend it or press F2 to place your cursor
in the cell and edit the formula.
Click here to
return to the Excel index.