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

Applies To: Excel for Mac 2011

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

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

Thank you for your feedback!

Change language