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