How to Show Formula instead of Value in Excel Cells?

Microsoft Excel returns the calculated result when you type a formula in Cells and hit Enter on the keyboard. However, due to some reason, if you want to display formulas in an Excel spreadsheet instead of calculated results, it is possible through the built-in Excel Options panel.

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 File menu.

Step 3. Click Options.

Step 4. Once done, the Excel Options panel will appear on your PC. Switch to the Advanced tab.

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 OK button.

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.”