Excel 2007 - how do I display formula instead of values? thanks.

[Trish]

--
Trish

 

[Riyaz]

Go to Tools/options and select formula box

 

[Ron de Bruin]

You can use the shortcut (working in all versions) to toggle the view

Ctrl `

Or use Office Button>Excel options..Advanced
See display options for this sheet

 

[Trish]

What great feedback from you both, and so useful! Thanks.