|
![]() |
![]() |
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 "Protection" aspect and click the Protection button to display the check mark. The entire worksheet is now protected. Next, highlight a range you want to unprotect. In the CellStyle Inspector select the "Input Type" aspect. Select the Unprot'd radio button. The range you selected is now unprotected. This is now the only area in which you are allowed to type. You can mark lots of different areas as Unprotected. 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. |
||
|
||