Press Ctrl + ` to show every formula on the active sheet in place of its result. The ` key is the grave accent, to the left of the 1 key. Press Ctrl + ` again to go back to the results.
If the shortcut does nothing on your keyboard layout, use the ribbon: Formulas → Show Formulas, in the Formula Auditing group. It is the same toggle.
Show Formulas applies only to the sheet you are on, and Excel widens the columns while it is on. Print with it switched on to get a printout of the formulas rather than the values.
To display one formula as text beside its result, use =FORMULATEXT(A2) (Excel 2013 and later). It returns #N/A if A2 holds a value rather than a formula.
If a cell shows its formula even with Show Formulas off, the cell was formatted as Text before you typed the formula. Change the format to General, then press F2 and Enter so it calculates.
Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
In Excel, there are so many formulas to use, and whenever you enter a formula in a cell, Excel shows the result of that formula.
But in some cases, you want to see the formulas in the cells to check them, and sometimes to print the data with the formulas instead of the results. For this, Excel has the option to show the formulas.
Keyboard Shortcut to Show Formulas
Like many other Excel features, there’s a keyboard shortcut to show the formulas in 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.

Steps to Show Formulas Using Keyboard Shortcut
- Click on any cell within the worksheet.
- After that, just press the keyboard shortcut keys Ctrl + `, and you will get all the formulas displayed instead of the results.
- To go back to view the resulting values, press the Ctrl + ` keys again.
The ` key is the grave accent key, usually just below the Esc key, on the same key as the tilde (~). Excel’s own list of shortcuts calls it Ctrl + grave accent. The shortcut works only for the active worksheet, and it switches the setting on and off each time you press it.
Show Formulas from the Ribbon
If the shortcut doesn’t work on your keyboard (on some non-US layouts the ` key is in another place), go to Formulas ➜ Formula Auditing ➜ Show Formulas. Click it again to go back to the results.
Things to Know
- Column width: Excel widens the columns while formulas are shown, and they go back to normal when you switch it off.
- Printing: when Show Formulas is on, Excel prints the formulas, so you can print a sheet with all its formulas.
- One formula only: to see the formula of one cell as text in another cell, use the FORMULATEXT function (formula below this list).
- Mac: on a Mac, the shortcut is Control + `.
=FORMULATEXT(A1)
Frequently Asked Questions
Why does Ctrl + ` not show my formulas?
Either your keyboard layout has the ` key in a different place, or the cells don’t have formulas (they may be values pasted over the formulas). Use Formulas ➜ Show Formulas instead.
Why do I see formulas instead of results without pressing anything?
Either Show Formulas is turned on for that sheet (press Ctrl + ` again), or the cells are formatted as Text. For Text cells, change the format to General and re-enter the formulas (press F2 and Enter).
Does Show Formulas apply to all the sheets?
No. It applies only to the active worksheet, so you need to turn it on for each sheet.