Showing forumlae instead of results

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

I have a large set of sheets (Excel 2000) that I need to verify a bunch of formulae. Is there any
way to have Excel show the formula in a cell instead of the results of the formula? I seem to
remember a formula view in some program I used at one time, but I can't find anything similar in
Excel 2000. The way it is now, I have to use the arrow keys and scroll down each column and read
each formula in the formula bar which is very time consuming, where if I could switch the display to
show the actual formulas, I could spot the bad ones at a glance.

Any help appreciated, thanks in advance.
Conf.
 
use ctrl + ~ ( tilde ) to view the formula mode.

or

go to tools | options | view tab | check formulas options | ok |
 
Excellent, thanks to both of you for the quick replies. I don't know how I
didn't see that in the options dialog, and the shortcut key will be most
useful.

Conf.
 
Back
Top