Microsoft Excel is one of the primary applications everybody has used at some point. You might know that whenever you type a formula in one of the cells, you get the calculated result after you press
When you want to create a demo spreadsheet or a table to display the sum of cells, percentage of data, etc., you might want to print an Excel spreadsheet with formulas. This risewindows article will show you how to skip displaying the calculated result and show the formulae in the Excel spreadsheet column.
How to Show Formula instead of Value in Excel Cells?
Use the following steps to display formula instead of value in Excel Cells: Permanently-
Step 1: First, go to the Microsoft Excel Worksheet on your system.
Step 2: Look for the
Step 3: Click on
Step 4: Once you complete the above steps, the Excel Options panel will appear on your computer. Switch to the
Step 5: Next, 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, it will change the settings. From now on, whenever you put a formula in the column of the spreadsheet, it won’t display the calculated result and instead will show the formula as it is.
In case you want to revert to the previous state of the application, you need to repeat the above steps and un-check the box “Show formulas in cells instead of their calculated results” in step 5. There you go. You will not revert; calculated results will be displayed as you enter a formula in the column.
That is it.
You guys are amazing; Keep reading, learning, and growing.
