Exceljet

Quick, clean, and to the point

Toggle formulas on and off

Windows shortcut 
Ctrl`
Mac shortcut 
`

This shortcut will toggle formulas and formula results, by enabling and disabling the Show Formulas button on the Formula tab of the Ribbon. You can use this shortcut to quickly see every formula in a worksheet, instead of the value it returns.

Related videos

The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use when building, editing, or entering formulas.
In this video, we show you three ways to find formulas in a worksheet, including a tricky way to use conditional formatting and a named formula to highlight formulas.