Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Viewing Formulas

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.

webmaster@allaboutoffice.co.uk