Excel Formula Display Help
September 22, 2008 9:46 AM Subscribe
I have an excel file full of formulas that span multiple sheets and rows. I would like to be able to go into a formula and see the actual data used in the formula rather than just the cell references.
So, for simplicity's sake, imagine A1=1,000, A2=2,000, A3=A1/A2
When I go to cell A3 and press "F2" or "cntrl`" the formula with the references shows up "=A1/A2".
What I would like to see is "=1,000 / 2,000"
(what you would get if you wrote =A1 &" / "& A2)
I know that I can do this sort of with the watch window or the evaluate formula but I am looking for a quick way to roll down a sheet and see the actual math that is being done without having to scroll all over the place or flip sheets.
Hopefully this makes sense. If not, I can further clarify.
No one at my office thinks that it is possible so I might just be out of luck but I live in a world of hope...
posted by GrumpyMonkey to Computers & Internet (5 answers total) 2 users marked this as a favorite