Excel show formulas shortcut: Ctrl + `
Show every formula in the sheet instead of its result, and switch back with the same keys.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
* Based on the keyboard layout, not tested on a real keyboard (only the Croatian one was tested). If the shortcut does not work, use the matching button on the ribbon.
What it does
Ctrl + ` (the key left of the 1, called grave accent or backtick) switches the sheet to formula view. Every cell that has a formula shows the formula itself, such as =B2*C2, instead of the number. Press the shortcut again to see the results.
When to use it
Use it to check a sheet you did not build, to spot a typed number hiding among formulas, or to find a broken reference. It shows all the formulas at once, so you do not have to click cell after cell.
How to do it
- Click anywhere in the sheet.
- Press Ctrl + ` (the key to the left of the number 1).
- Every cell shows its formula. Press Ctrl + ` again to see the numbers.
A quick example
In the orders table, column D holds =B2*C2 and the sum =SUM(D2:D7). Click any cell and press Ctrl + `: column D now shows =B2*C2, =B3*C3 and so on, and the sum row shows =SUM(D2:D7). Press Ctrl + ` again and the totals come back.
Ctrl + `, F2 and the formula bar
Ctrl + ` shows all formulas at once. F2 edits one cell and highlights the cells it uses. The formula bar shows the formula of the selected cell only. Pick Ctrl + ` when you want to check a whole sheet.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar or a search box.
- You cannot find the key: it is the grave accent or backtick, usually left of the 1. On some keyboard layouts it sits elsewhere, so look for the grave accent mark.
- Some cells still show numbers: they are typed values, not formulas. That is exactly what the shortcut helps you find.
- The numbers do not come back: press Ctrl + ` once more. It switches between the two views.
- On a Mac use Control + `.
Quick answers
What is the shortcut to show formulas in Excel?
Press Ctrl + `, the grave accent key to the left of the 1. Every formula in the sheet is shown instead of its result.
How do I switch back to the results?
Press Ctrl + ` again. It works like a switch between formulas and results.
Why do some cells show numbers in formula view?
Those cells hold typed values, not formulas. This is a quick way to find numbers typed over a formula.
Can I see only one formula?
Yes. Click the cell and read the formula bar, or press F2 to edit it and see the cells it uses.

