excel advanced - formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel advanced - Formulas

excel advanced - Formulas

resolvedResolved · Low Priority · Version Standard

Lisa has attended:
Excel Intermediate course

Formulas

How do i view the formulas only?

RE: 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

RE: Formulas

Thank you :-)

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.08 secs.