Turn off editing directly in a cell

By default, you can edit the data in a cell by using either the formellinje or by editing the data in the cell itself. To help protect your sheet, you can turn off the ability to edit data directly in the cell, which requires all changes to be made using the formula bar.

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click Edit  Knappen Rediger indstillinger .

  3. Clear the Double-click allows editing directly in the cell check box.

See also

Freeze column headings for easy scrolling

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!