Microsoft Office Tutorials and References
In Depth Information
Protecting workbooks and worksheets
If you want to allow anyone to open a workbook but want to prevent unauthorized users
from editing a worksheet, you can protect a worksheet by displaying that worksheet,
clicking the Review tab and then, in the Changes group, clicking Protect Sheet to open the
Protect Sheet dialog box.
In the Protect Sheet dialog box, you can select the Protect Worksheet And Contents Of
Locked Cells check box to protect the sheet. You can also set a password that a user must
enter before protection can be turned off again, and choose which elements of the
worksheet a user can change while protection is turned on. To allow a user to change a
worksheet element without entering the password, select the check box next to that element’s
The check box at the top of the worksheet mentions locked cells. A locked cell is a cell that
can’t be changed when worksheet protection is turned on. You can lock or unlock a cell by
right-clicking the cell and then clicking Format Cells. In the Format Cells dialog box, you
click the Protection tab and select the Locked check box.