vert line

Within your worksheet, you can designate protected and unprotected cells. Typically you'll do this if you have a sheet where you don't want users to overwrite formulas and headings by mistake.

When you create a new worksheet, protection is off by default. After you have built a structure that requires some ranges to be protected and others open for data entry, you should do the following:

  • In the Sheet Inspector select the "Enable Protection" aspect and tick the Check-Box . The entire worksheet is now protected.
  • Anyone using the sheet can turn off the Sheet Protection. Setting protection is not a guarantee that no-one will ever delete your formulas or overwrite constant data.

See also

 

Also go to:

Index help

Contents help