Show formulas in excel shortcut key mac

shortcut key show formulas excel

short cut key to show formula in excel

shortcut key to show all formulas in excel

show formulas in excel shortcut key f2

Excel show formula instead of value

Display cell formulas in excel

How to hide cell formulas in excel

Excel show formula as text in another cell

Excel show formulas in selected cells

How to hide cell formulas in excel!

By default, whenever you enter a formula in Excel and hit theenter key, it is going to show you the result of that formula.

While this is the desired output in most cases, in some cases you may want to show the formula that is being used in the cell instead of showing the result of that formula.

One scenario where this could be useful is when you’re auditing formulas to identify errors or incorrect cell references

And this can easily be done with a simple keyboard shortcut

In this tutorial, I will give you the keyboard shortcut to Show Formula (Instead of Formula Result) in Excel

Shortcut to Show Formula (Instead of Formula Result) in Excel

Below is the keyboard shortcut to Show Formula (Instead of Formula Result) in Excel:

Control + `

How to Use the Keyboard Shortcut to Show Formula (Instead of Formula Result) in Excel

Below are the steps to use the above keyboard shortcut:

Activate the worksheet in which you want to show the formulas instead of the formula values
Use the above keyboard shortcut Control + ` (hold the control key and then press the back qu