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.

 Tip   

  • 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