ExcelTutorials

How to Display/Show Formulas in Excel

2 Mins read

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. This Excel Trick will help you to Display/Show Formulas in Excel without any issues. Similarly, for more such tips & tricks you can follow our Excel Ninja Training and become an expert 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.

Excel Vlookup formula – Picture Guidebook

Excel Vlookup Formula

Bored of downloading text heavy / copy-pasted eBooks?

If Yes, you will enjoy this picture-based guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.

How to Display/Show Formulas in Excel?

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 the same as the 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 sales for each product. Cells of Column D and E have 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 the 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.

  • Step 1: Click on the ‘Formulas’ tab in the ribbon.
  • Step 2: In the Formula Audition Group Click ‘Show Formulas’
  • Step 3: Result: You can sell all formulas inside cells.
Click on File tab to move into Backstage View

Excel Vlookup formula – Picture Guidebook

Excel Vlookup Formula

Bored of downloading text heavy / copy-pasted eBooks?

If Yes, you will enjoy this picture-based guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.

Way 3: from File tab!

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

the Excel Options dialog box appears, we select the Advanced from the left side

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

the Advanced category is selected, scroll down in order to locate the area named Display Options For This Worksheet

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 the OK button on the Excel Options dialog box in order to return to our Worksheet.

15 Excel Data Cleaning Tricks Guidebook

Bored of downloading text heavy / copy-pasted eBooks? If Yes, you will enjoy this guidebook (43 pages) 

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 a single click in that cell that contains a 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. Here B2, C2, and D2 are selected.

Pivot Tables – Guidebook for Pros

15 Pivot Table tricks to make your Excel data analysis smarter! 5,600+ downloads. Most Popular Tricks are #3, #7 & #12

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…