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:
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.
Once in the Excel Options dialog window go to the Advanced options.
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.
Now select the option for Show formulas in cells instead of their calculated results.
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.