View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan G Dan G is offline
external usenet poster
 
Posts: 5
Default How can I display formula values instead of the formula?

Gotcha, I was hitting single quote.
Doing this seems to show the same as hitting F2 which just shows the
formula. Am I still not getting it? (Or not explaining what I am looking for
well enough more likely...)

I am thinking that I might just be out of luck.





"Dave Peterson" wrote:

That's ctrl-backquote (the key to the left of the !/1 on my USA keyboard).

Or you could use:
tools|options|view tab|check formulas
(xl2003 menus)

Dan G wrote:

That seems to just show me the formula from the cell above the one that I am
currently in.

"Spiky" wrote:

Press CTRL-`. It's a toggle, so press it again to turn off.


--

Dave Peterson