Toggle Formulas On and Off

Using the Toggle Formulas On and Off Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut enables and disables the Show Formulas button on the Formula tab of the Ribbon. This toggles formulas and formula results.

Use this shortcut to quickly see every formula in a worksheet.
Other useful Formula keyboard shortcuts