View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default show formula instead of value

Rasoul

If you just want to show this temporarily then Ctrl+` (On a UK keyboard).
It's the key above Tab.

If you want it permanently, say to print, etc, prefix the formula with a
single apostrophe '

It will not show but the formula will

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"Rasoul Khoshravan" wrote in message
...
how can I show the formula inside a cell, instead of its value?