How to Display Formulas in Excel

If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and keep track of all your formulas. Excel provides a simple way of displaying formulas in the cells instead of the result.

How to display formulas in Excel?

Imagine that when you add formulas to your Excel spreadsheet, they are hidden when printing and viewing the sheet. If you’d rather show the formulas on your sheet instead of the formula’s results, you can do it using three ways which will be discussed in this tutorial.

So, Let’s Show Formulas in Excel Instead of the Values with those three ways!

the ratio between these two shop’s sale for each product

Way 1: Shortcut Command!

Step 1: Say we have a table same as like above picture. This table is showing the number of sales of two electronics shops and column E is showing the ratio between these two shop’s sale for each product. Cells of Column D and E has a formula which is calculating the ratio. Now we want to display the formulas of these cells so that we can print it.

Here is the shortcut way: Just press “Ctrl+` ”

Here is the shortcut way:

Just press “Ctrl+` ” from your keyboard and see the Magic! All formulas of column D and E are showing in our excel sheet as like above picture.

“ ` ” this symbol you can find on the left side of key 1 on your keyboard.

Go to Formulas tab. From Formula Auditing group click Show Formulas
Way 2: From Formula tab!:

Now let see another way to show formula from the Menu bar.

  • Click on the ‘Formulas’ Tab in the ribbon.
  • In the Formula Audition Group Click ‘Show Formulas
  • Result: You can sell all formulas inside cells.

Click on File tab to move into Backstage View

Way 3: from File tab!

Step 1: Click on File tab to move into Backstage View. Once in Backstage View, from the drop-down menu select the category Options from the left as shown above picture.

display formula in excel

Step 2: Now the Excel Options dialog box appears, we select the Advanced from the left side as like above picture.

show formula in excel

Step 3: Once the Advanced category is selected, scroll down in order to locate the area named Display Options For This Worksheet. Check Show Formulas In Cells Instead Of Their Calculated Results. Once activated, press OK button on the Excel Options dialog box in order to return to our Worksheet.

Now all formulas are showing in all cells.

Now all formulas are showing in all cells

After checked on Show Formulas In Cells Instead Of Their Calculated Results we can see that Show Formulas is also activated from the Formula tab

Tips 1: After checking on Show Formulas In Cells Instead Of Their Calculated Results we can see that Show Formulas is also activated from the Formula tab. If we click on it again, then formulas will be invisible.

Tips 2: When you activate Show Formulas and formulas are visible and If you need to see those cells which are included inside the formula of a particular cell, You can see this by single click in that cell that contains formula. Say, in our this example we want to see those cells which are included in the formula of cell E2. So, we just need to single click on E2, then beside E2 those included cells are also selected with different colors. In here B2, C2 and D2 are selected.

So, these are how we can show formulas in Excel! Enjoy Excel Tips…!

Related Tutorials

Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
Insert a Picture into a Cell in Excel
May 25, 2018
What is ISFORMULA Function and FORMULATEXT Function
May 21, 2018
How to Use SUBSTITUTE Function
May 21, 2018
Excel Quartile Function in Excel
May 8, 2018
How to use the Excel PERCENTILE function
May 7, 2018
Insert or Type degree symbol in Excel with Autocorrect Feature
May 7, 2018