excel advanced - Formulas

Good morning Lisa,

To answer your question on viewing formulas:-

I can offer you two different options, one using the menu and mouse and the other using the keyboard.

If you go into the Tools menu and down to "Options" this will bring up a dialogue box and if you select the "View" tab at the top, then make sure the Formula box is ticked, this is near to the bottom of the box on the left hand side.

The other shortcut using the keyboard is to press the Ctrl button down and press the button to the left of the number 1 key. When these are held down you can toggle between formulas and numerical answers.

Good luck

Tracy