LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Excel Tips

2 Ways to Show Formulas in Excel

In this article you will learn two quick ways to see underlying formulas in Excel.

What are some uses of the “Show Formulas” feature in Excel?

The "Show Formulas" feature in Excel can be useful for several reasons:

  1. Checking formulas: By showing formulas, you can easily check if the formulas in your worksheet are correct. This can help you catch errors and make sure that your calculations are accurate.
  2. Debugging: If you have a formula that is not working correctly, showing the formula can help you identify where the problem is. This can be particularly useful for complex formulas.
  3. Sharing: If you need to share your workbook with someone else, you may want to show the formulas so that they can see how the calculations are being done.
  4. Learning: If you are new to Excel or learning how to use a specific function or formula, showing the formula can help you understand how it works.
  5. Printing: Sometimes you may want to print out a worksheet with formulas displayed instead of the actual values. This can be useful if you need to share the worksheet with someone who needs to see the formulas.

In summary, the "Show Formulas" feature in Excel can help you check formulas, debug problems, share workbooks, learn Excel, and print worksheets with formulas displayed.

How to show formulas in Excel?

To show a formula in Excel, you can use one of the following methods:

Method 1: Show Formulas Option

Go to the "Formulas" tab in the ribbon, and click on "Show Formulas" in the "Formula Auditing" section. This will change the display of the cells to show the formula instead of the result. 

How to show formulas in Excel: Method 1

Method 2: Shortcut Key:

Go to the cell where you want to see the Formula, pressing the "Ctrl" + "`" (grave accent) key on your keyboard will toggle between showing the formulas and the results.

Note: If you use any of these methods to show formulas in a worksheet, it will affect the entire workbook, not just the current sheet. To turn off the display of formulas, you can use the same methods again.

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow 

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.