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

--
Trish

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

Go to Tools/options and select formula box

"Trish" wrote:


--
Trish

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

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

Ctrl `

Or use Office ButtonExcel options..Advanced
See display options for this sheet




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trish" wrote in message ...

--
Trish

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

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


"Trish" wrote:


--
Trish