How to Show Formula instead of Value in Excel Cells?

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 Enter. However, if you want the cells to display the formulae only and not the calculated result, you can use the built-in Excel Options panel.

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 File menu and open it.

Step 3: Click on Options.

Step 4: Once you complete the above steps, the Excel Options panel will appear on your computer. Switch to the Advanced tab.

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

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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: