How to Display the Cell Formulas in Excel (6 Methods)

While working on a spreadsheet in Excel with tons of data and formulas, you may feel the necessity to display the cell formulas at once for several reasons. You may want to edit them, understand how they are working, or even how different cells are related to each other. Whatever the purposes you possess, go through the whole article carefully because you are going to learn six distinct methods to display the cell formulas in Excel step by step.


Download the Practice Workbook

You are recommended to download the practice workbook and practice along with it.


6 Methods to Display the Cell Formulas in Excel

Suppose an ice cream vendor produces ice cream having 5 different flavors and sells them throughout the USA, UK, and Canada. We’ve tried to calculate how much the company sells to those countries by flavor and region separately.

dataset to demonstrate how to display cell formulas in excel

To calculate the total sales, we’ve used the SUM function. Now, we are going to discuss 6 distinct methods that you can use to make the sum formula visible in Excel.


1. Display the Excel Cell Formulas Using the Formula Bar

This is the quickest way to display individual cell formulas in Excel. Follow the steps below to learn:

🔗 Steps:

Click on cell F5  to see the formula that has been entered within it.

Get the corresponding formula ▶  in the Formula Bar.

how to display cell formulas in excel using formula bar


2. Reveal the Excel Cell Formulas Using Double-Click

If you want to display an individual cell formula within the cell it was used instead of the Formula Bar, then follow this method:

🔗 Steps:

Select the cell F5 ▶  to see the formula that has been entered within it.

Double-Click on it.

reveal the cell formulas using double click


3. Display the Cell Formulas Using a Keyboard Shortcut

You can use this keyboard shortcut to display all the formulas used within a spreadsheet. This is the quickest way to show all the formulas used in all cells within a data table.

🔗 Steps:

Press CTRL + `.

🔎  You can find the Grave Accent Key (`) right below the ESC button on the keyboard.

display cell formulas using keyboard shortcut in excel


Similar Readings:


4. Use the FORMULATEXT Function to Exhibit the Cell Formulas in Excel

If you want to show a formula within a specific cell of your spreadsheet, this method is for you. Because the FORMULATEXT function will enable you to display any formula in any cell on a spreadsheet in Excel.

🔗 Steps:

Select cell C12 ▶  to view to formula.

Type

=FORMULATEXT(C10)

in cell C12.

❸  Press the ENTER button.

formulatext function to show cell formulas in excel

 


5. Display the Excel Cell Formulas Using the Show Formulas Command 

This is another way to show all the formulas used in all cells in Excel. If you ever forget the keyboard shortcut to reveal the cell formulas in Excel, you can follow this method to accomplish the same task.

🔗 Steps:

Go to the Formulas ribbon.

Now click on the Formula Auditing option.

❸  Select Show Formulas from the list.

use of show formulas command in excel

Then you will have all the formulas shown like this:


6. Show All the Excel Cell Formulas Using Advanced Options

This method is a bit lengthy. You are recommended to follow this method only in those situations when you don’t want to display the formula results but the formulas.

🔗 Steps:

Go to the File ribbon.

use of advanced options to show cell formulas in excel

Then click on Options.

Now select Advanced from the Excel Options window.

Go to Display options for this worksheet: section.

Mark the Show formulas in cells instead of their calculated results checkbox.

After that you will see all the formulas like this:


Things to Remember

📌 CTRL +` is the hotkey to display cell formulas.

📌 Formula Bar is the dedicated scope to show cell formulas in Excel.

📌 FORMULATEXT is a built-in Excel function to display cell formulas.


Conclusion

In this article, we’ve demonstrated six distinct methods to display cell formulas in Excel. You are recommended to practice all of them along with the attached practice workbook that has been prepared exclusively for your practice purpose. Don’t forget to leave any questions in the comment section, you all try to respond to your problems asap.


Related Readings

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo