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 will have not yet affected the document.You must first enable Sheet protection for these settings to take effect.

Note: Enabling sheet protection only affects the current worksheet.

To enable sheet protection for a worksheet, proceed as follows:

1.Choose the ribbon command Review | group Protection | Sheet protection sheet_protect_icon_a.
2.If desired, you can now enter a password that the user must enter in order to disable sheet protection again.
If you do not want to assign a password, simply leave the input field blank.
3.Confirm with OK.

The sheet protection is now enabled; the protection settings of the cells now take effect.

You notice this, among other things, by the fact that you can only edit cells for which the option Protect cell has not been enabled. These cells are displayed with a small green triangle in their lower right corner. This allows you to see immediately which cells can still be changed when 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.

If sheet protection is enabled, there are also the following restrictions:

Most commands for editing the worksheet are unavailable.

Position, size and all other properties of objects can no longer be changed (except for objects for which you have disabled the Locked property).

Text in text frames can no longer be changed (except for objects for which you have disabled the Text locked property).

New objects can no longer be inserted into the worksheet.