How To Show Formulas In Excel

3.7 min read|Last Updated: January 8th, 2024|Categories: Excel|
table of content

In this article, we will discuss how to display formulas in Excel with some simple methods. When we are working on an Excel spreadsheet and formulas, sometimes we need to know which formulas are used in each cell. Excel will automatically hide formulas and just show the results. Here we learn how to show formulas in Excel instead of the values.

How to Display Formulas in Excel

There are many methods to display formulas in Excel. We will show you how to check the formulas with the help of some simple and quick ways.

1. Show Formulas Option on the Excel Ribbon

You can show formulas using the Excel ribbon. To do this, you can choose the “Show Formulas” item. First, select the cell which contains the result, then go through the Formulas tab within the Formula Auditing range and choose the “Show Formulas” item. This option will display the formula instantly.

show formula option on the Excel Ribbon in formula tab to show formulas in excel

2.