- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Formulas Instead of Values in Excel 2007

Posted By On April 20, 2009 @ 4:25 PM In MS Excel,MS Office Help | No Comments

I’m sure that many of my Excel users know how valuable it can be at times to see formulas in your worksheet instead of their calculated values.

I mean, sometimes you just need to verify that everything is calculated the way you need it and often the easiest way to accomplish the task is to double-check the formula.

So… it stands to reason that Excel would include a way to display the formulas on a worksheet for you to inspect. And, of course they do.

For those of you using older versions of MS Excel you can find the instructions for getting Excel to display formulas instead of values in our archives at this address:

http://www.worldstart.com/tips/tips.php/1132

Now, for my Excel 2007 readers… did you find it yet?

The option is still there, you just have to know where to find it.

You need to get to Excel’s options through the Office button.

image

Once in the Excel Options dialog window go to the Advanced options.

image

Scroll down to the Display options for this worksheet section.

Verify that the sheet you want to affect is selected in the gray title bar.

image

Now select the option for Show formulas in cells instead of their calculated results.

Click OK.

When returned to your worksheet you should see numbers only where an actual numeric data piece is located, text and formulas.

Time to get busy editing… yeah, I know, more work to do but hopefully this will make it easier.

~ April


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/formulas-instead-of-values-in-excel-2007/