Display formulas in cells

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click View   Excel View Preferences button .

  3. Under Window options, select the Show formulas check box.


    • When the option to display formulas is turned on, you can switch between viewing the values and the formulas that produce the values by pressing CONTROL + ` (grave accent).

    • You can also hide formulas by turning on sheet protection. For more information, see Protect a sheet.

See also

Protect a sheet

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!