Display formulas in cells

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click View   Knappen Vis indstillinger i Excel .

  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

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!