Protect a Worksheet
Worksheet protection locks the cells so that you can only perform a specific (restricted) set of actions.
By default, all cells in the worksheet are locked. When protection is applied to the worksheet, these cells become read-only. However, you can specify certain actions which can be performed with the locked cells in a protected worksheet.
To protect a worksheet, use the following dialog:
To invoke this dialog, on the Review tab, in the Changes group, click the Protect Sheet button.
Protect a Worksheet
Worksheet protection locks the cells so that you can only perform a specific (restricted) set of actions.
By default, all cells in the worksheet are locked. When protection is applied to the worksheet, these cells become read-only. However, you can specify certain actions which can be performed with the locked cells in a protected worksheet.
To protect a worksheet, use the following dialog:
To invoke this dialog, on the Review tab, in the Changes group, click the Protect Sheet button.
In a protected sheet, this button displays the "Unprotect Sheet" caption, which invokes a simple dialog that prompts for a password or unlocks the sheet if an empty password was set.
In a protected sheet, this button displays the "Unprotect Sheet" caption, which invokes a simple dialog that prompts for a password or unlocks the sheet if an empty password was set.