• Toggle Formulas Off and On

  • Toggle Excel Formulas Off and On 

    A simple keyboard shortcut to switch the view between displaying cell values and the formulae that are in the cells.

    This is useful for quickly displaying all the formulae in a worksheet.

    Hold the CTRL key and press `

     

    Note: the ` is usually to be found on the keyboard below the Esc key.