I have a bunch of cells that contain formulas with values from all over the
place and
I would like to be able to see the values of each formula quickly.

To simplify, using the example formula =(A1+B2)/C3*D4)
I would like to see =(1+2)/3*4

I know I can sort of do this with the watch window or I can do something
like this -
="(" & A1 &" + "& B2 &") / "& C3 &" * "& D4 - in another cell but neither of
those are what I need. The watch window does not show the whole formula at
once and the 2nd is not easily replicated for many cells.

Thanks for looking,
Dan

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

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.

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

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

I think you're right that we aren't communicating well.

F2 moves you into Edit mode in one cell.

But simpler for one cell at a time is to simply have the Formula Bar
showing and look up there to see the formula.

CTRL-` moves you into the Show Formulas view, which shows all the
formulas in the sheet. Although if they are long, it won't necessarily
show every character in the formula.

There is a UDF which is part of morefunc (search on download.com)
which will show formulas in a different cell. It's called FORMULATEXT,
and it simply shows a formula as the value in a cell. Like this:
=FORMULATEXT(A1) .....this will show whatever the formula looks like
in A1.