Show formulas instead of results

[Guest]

I am trying to have the actual formulas show up on my spreadsheet, instead of
the results. I think I have done it before, but I can't remember now.

Thank you

 

[Niek Otten]

Tools>Options>View, check Formulas

 

[damorrison]

goto tools and options, select formulas

 

[Peo Sjoblom]

Ctrl + ` (grave accent same key as tilde) toggles it off and on, or
tools>options>view>formulas

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Guest]

Press CTRL and ` (the grave accent key to the left of the number 1 at the top
of the keyboard). This shortcut will toggle between the formulas and values.

Andrea Jones
www.allaboutoffice.co.uk
www.stratatraining.co.uk
www.allaboutclait.com