Learn › Excel › Show formulas

Excel show formulas shortcut: Ctrl + `

Show every formula in the sheet instead of its result, and switch back with the same keys.

← All Excel shortcuts

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.

WindowsCtrl+`
MacCtrl+`

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.

English (US)Ctrl+`
HrvatskiCtrl + AltGr + 7 does not work (tested). Use Formulas tab → Show Formulas.
DeutschStrg+` *
EspañolCtrl+` *
FrançaisCtrl+` *
PortuguêsCtrl+` *
ItalianoCtrl+` *
TürkçeCtrl+` *
Bahasa IndonesiaCtrl+`
PolskiCtrl+`

* 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

  1. Click anywhere in the sheet.
  2. Press Ctrl + ` (the key to the left of the number 1).
  3. Every cell shows its formula. Press Ctrl + ` again to see the numbers.
Good to know: Formula view changes only how the sheet looks, not your data. To read a single formula, you can also click the cell and look at the formula bar.

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:

Lock a cell reference ($)F4Edit a cellF2Sum a column (AutoSum)Alt+=

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.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games