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

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!