Show Formulas – Keyboard Shortcut

HomeExcel Keyboard ShortcutsShow Formulas – Keyboard Shortcut

In Excel, there are so many formulas to use and whenever the user enters the formula in any cell, Excel shows the resulted 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 resulted values and for this Excel has the options 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:

shortcut-to-show-formulas

Ctrl + `

In the below example, we have pressed the “Ctrl + `” keys and Excel displayed all the existing formulas instead of their resulted 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 resulted values.
  3. To go back to view the resulted values, press the “ Ctrl + ` “ keys again.

Excel Shortcuts Cheat Sheet (PDF)