View cell info instead of formulas / Evaluate formulas

Hi - i've turned the view to the formula's within the cell's opposed to the result of said formula's... i was wondering how to change it back, ? ( See attached image)

Screen shot 2012-05-20 at 14.50.55.png

Also - i was wondering how to show " Evaluate Formula " ? Im on mac 2011.... I've been going through this video -

http://www.youtube.com/watch?list=PL...YssT5XQ#t=279s

(that should play at the correct time)

pretty basic stuff i know guy's, but any help would be appreciated.

cheers!

Hi,

don't know about Mac, but in Excel for Windows, you use Ctrl-~ to toggle between formula and normal view.

The Evaluate Formula command is found on the Formulas ribbon. You can put it in the QAT (if that exists on the Mac, that is) for easy access.

hey pam - I changed the view to normal now.... But i'm still unsure about the evaluate formula's option...

here's a screenshot of what i understand to be the formula's ribbon :

Screen shot 2012-05-20 at 15.05.16.png

Where about's on there is the evaluate formula's thing, ?

Sorry im at mega entry level on this, much appreciated though.