Microsoft Office Tutorials and References
In Depth Information
Using worksheet protection
3. In the Format Cells dialog box, click the Protection tab and remove the checkmark from
the Locked check box.
4. Choose Review
Protect Sheet to display the Protect Sheet dialog box.
5. In the Protect Sheet dialog box, remove the checkmark from the Select Locked Cells
check box (see Figure 24-2).
6. If desired, specify a password that will be required in order to unprotect the sheet and
then click OK.
Figure 24-2: Use the Protect Sheet dialog box to prevent the user from selecting locked cells.
After you perform these steps, only the unlocked cells (those you selected in Step 1) are
Worksheet passwords are not at all secure. In fact, it’s a trivial matter to crack such a
password. Therefore, worksheet protection is more of a convenience feature than a