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
|