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.
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:
❶ Click on cell F5 ▶ to see the formula that has been entered within it.
❷ Get the corresponding formula ▶ in the 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:
❶ Select the cell F5 ▶ to see the formula that has been entered within it.
❷ Double-Click on it.
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.
❶ Press CTRL + `.
🔎 You can find the Grave Accent Key (`) right below the ESC button on the keyboard.
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.
❶ Select cell C12 ▶ to view to formula.
in cell C12.
❸ Press the ENTER button.
- How to Select Cells in Excel Using Keyboard (9 Ways)
- If One Cell Equals Another Then Return Another Cell in Excel
- How to Select a Range of Cells in Excel (9 Methods)
- Selecting Non Adjacent Cells in Excel (5 Simple Ways)
- How to Select Multiple Cells in Excel (7 Useful Methods)
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.
❶ Go to the Formulas ribbon.
❷ Now click on the Formula Auditing option.
❸ Select Show Formulas from the list.
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.
❶ Go to the File ribbon.
❷ 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.
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.