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.

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

*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+` **” 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.

*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.

*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.

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

**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

** 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…!