Microsoft Excel returns the calculated result when you type a formula in Cells and hit
You might want to show the formula instead of the value in an Excel spreadsheet for some reason, such as creating a demo spreadsheet to teach someone where you want to display the sum of cells, percentage of data, etc. Or, you may wish to print an Excel spreadsheet with formulas.
In this gearupwindows article, we will guide you on displaying Formula instead of Value in Excel Cells.
How to Show Formula instead of Value in Excel Cells?
To permanently display formula instead of value in Excel Cells, use these steps:-
Step 1. Open Microsoft Excel Worksheet on your computer.
Step 2. Click on the
Step 3. Click
Step 4. Once done, the Excel Options panel will appear on your PC. Switch to the
Step 5. Now, head to the “Display options for this worksheet” section and check the checkbox “Show formulas in cells instead of their calculated results.”
Step 6. Click the
Once you complete the above steps, every cell of the Excel spreadsheet where you have put the formula will start displaying the formula instead of cell values.
If you want to revert the changes and display values in cells, repeat the above steps, and in step 5 above, uncheck the checkbox “Show formulas in cells instead of their calculated results.”