Formulas+in+Excel

Formulas in Excel There are occasions when you need to see the formulas in an Excel Spread sheet and not the values, just to ensure yourself that you have entered it correctly

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 this manner:-

Go to:-

Options options as in, Tools menu, Options Nextgo to the View tab.

In the Windows options section (at the bottom) scroll to the Formulas choice. Place a tick/check in the box. Then click OK.

The display will be returned to your worksheet where everything is now displayed as a formula, not a value. (Unless the data entered was a number – not a formula.)

If you were to print now you will get a printout with the formulas instead of the values.

This setting will stay until you go back to the Options window and uncheck/tick the Formulas choice. That is how to return to the calculated numbers for printing

In Excel 2007 readers 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. Click OK. When returned to your worksheet you should see numbers only where an actual numeric data piece is located, text and formulas, and of course if you want to see the results also set the results to display in the next box.

Please post your comments in :- [|Queries and Comments]  