Show Formulas (Excel Shortcut)

puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

In Excel, there are so many formulas to use and whenever the user enters the formula in any cell, Excel shows the resulting values of that formula.

But in some cases, users want to see the cells containing formulas to view and validate the formula and sometimes to print the data with the formulas instead of the resulting values and for this Excel has the option to show the existing formulas.

Keyboard Shortcut to Show Formulas

Like, many other Excel features and functions, Excel also has a keyboard shortcut defined to show the existing formulas within the worksheet.  The keyboard shortcut for showing the formulas is:

Ctrl + `

In the below example, we have pressed the “Ctrl + `” keys and Excel displayed all the existing formulas instead of their resulting values.

formulas-displayed

Steps to Show and Formulas Using Keyboard Shortcut

  1. Click on any cell within the worksheet.
  2. After that, just press the keyboard shortcut keys Ctrl + ` and you will get all the formulas displayed instead of the resulting values.
  3. To go back to view the resulting values, press the Ctrl + ` keys again.
Last Updated: January 10, 2024