Display cell formulas

K

Ken

How do I set the default option for Excel to display the
formula in a cell when that cell is selected rather than
the value? I have Office for Mac OS x version.
 
D

David McRitchie

Hi Ken,
Tools, Options, View, Formulas

You can toggle on a PC with Ctrl+` accent grave

I expect that would equate to the key in the lower
left and the accent grave to the left of the number row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top