Question:-How to Show Formulas in Microsoft Office Excel Instead of Their Results?
Answer:-Showing Formulas in Microsoft Office Excel Instead of Their Results
Sometimes you want to display formulas in an Excel worksheet instead of their results. Here’s how:
1. Click the Office button, and then click Excel Options at the bottom of the menu.
2. Click Advanced, click Display options for this worksheet, click Show formulas in cells instead of their calculated results, and then click OK.