HomeHow toHow to Show Formula instead of Value in Excel Cells?

How to Show Formula instead of Value in Excel Cells?

How to Showcase Formulas Over Calculated Results in Microsoft Excel.

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.


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.


Leave a Comment

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

AOMEI FoneTool Giveaway: Securely Transfer, Backup, and Erase iOS Data for Free

In today's digital age, our smartphones play a pivotal role in our daily lives, storing essential data, cherished memories, and important documents. Whether upgrading...

Get WinX HD Video Converter Deluxe: A Limited-Time Giveaway for a Free License

In the evolving world of digital media, the need for high-quality video conversion, compression, and editing has become imperative. The market offers a plethora...

Ashampoo Uninstaller 11 Giveaway: Grab Your Free License Now!

For years, computer enthusiasts and regular users alike have faced the challenge of removing software entirely from their systems. Some programs, even after being...

Free Giveaway: Aiseesoft iPhone Password Manager – Effortlessly Manage and Secure Your Passwords

In the era of smartphones and digital dependence, our lives have become intricately woven into the fabric of the digital world. From emails to...

Free Giveaway: Unleash Your Video Editing Creativity with AVS Video ReMaker

In the digital age, video content has become a universal language. Whether you're a budding content creator, a passionate vlogger, or someone who simply...