Microsoft Excel is one of the primary applications that has become an integral tool for students, professionals, and businesses alike. Almost everyone has delved into its vast functionalities at some point in their life. One of the most utilized features is the ability to perform calculations using formulae. Typically, when you input a formula into a cell and press ‘Enter,’ Excel instantly showcases the calculated result. But what if you want the opposite? There might be instances when displaying the raw formulae rather than their results becomes essential, especially when creating a demonstrative spreadsheet or when preparing a table to exemplify various calculations such as sum, percentage, and more. If you’ve ever found yourself in this situation, there’s no need to fret. Excel’s built-in options panel provides a simple solution. In this risewindows guide, we’ll unravel the steps to ensure your Excel cells proudly display the formulae, sidelining the calculated outcome. So, the next time you aim to print an Excel spreadsheet with formulas at the forefront, you’ll be well-equipped.
How to Show Formula instead of Value in Excel Cells?
Use the following steps to display the formula instead of the value in Excel Cells permanently:-
Step 1: First, open the Microsoft Excel Worksheet on your system.
Step 2: Look for the File menu and click on it to 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 onwards, 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 uncheck the box “Show formulas in cells instead of their calculated results” in step 5. There you go. The calculated results will be displayed as you enter a formula in the column.
Conclusion
Microsoft Excel’s adaptability allows users to toggle between viewing actual calculated results and the underlying formulas with relative ease. Whether for educational or demonstrative purposes, having the flexibility to display formulas can be incredibly beneficial. This guide serves as a handy resource for those looking to make this switch, ensuring that the formulae, rather than their outcomes, take center stage in their spreadsheets.
