EXCELViewing FormulasTo 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. |
