Step 2: Enabling sheet protection

<< Click to Display Table of Contents >>

Step 2: Enabling sheet protection

The second step in protecting cells is to enable sheet protection for the current worksheet.

This is because if you have changed the protection settings of cells (as described in the first step "Setting up protection settings for cells"), this does not yet affect the document. You must first enable Sheet protection for these settings to take effect.

Note: Enabling sheet protection affects the current worksheet only.

To enable sheet protection, proceed as follows:

1.Choose the ribbon command Review | group Protection | Sheet protection sheet_protect_icon_a.
2.If desired, enter a password required to disable sheet protection.
Leave blank if you do not want to assign a password.
3.Confirm with OK.

The sheet protection is now enabled; the protection settings of the cells are now effective.

After that, only cells not flagged with the Protect cell option can be modified. These cells are displayed with a green triangle in their lower right corner. This allows you to see immediately which cells can still be changed when the sheet protection is enabled.

Tip: If sheet protection is enabled, only editable cells can be accessed when moving around in the table with the Tab key. Protected cells are skipped.

In addition, if sheet protection is enabled, the following restrictions apply:

Most commands for editing the worksheet are unavailable.

Size, position and all other properties of objects cannot be changed anymore (except for objects where you have disabled the Locked property)

Text in text frames cannot be changed anymore (except for objects where you have disabled the Text locked property)

New objects can no longer be inserted into the worksheet.