Showing forumlae instead of results

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.
 
M

muddan madhu

use ctrl + ~ ( tilde ) to view the formula mode.

or

go to tools | options | view tab | check formulas options | ok |
 
C

Confused

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing SQL query results in a list of columns, instead of one long column 1
Showing Formula in Cells and not Results 3
VLOOKUP returns formula instead of result 1
Copy cell formula returns zero instead of cell value 1
Switching From A Results View To Showing The Formula In A Cell ? 2
Formula nesting with IF statements 2
Directing the output of one cell into another cell 11
Excel How to get output of the formula instead of True or false 1

Top