Protect an Excel Worksheet

Excel makes it easy to protect unauthorized users from making changes to your worksheet. You can protect the entire worksheet or just specific cells.

---

---

How To Password Protect a Worksheet:

1. From Tools menu choose Protection. Slide right to Protect Sheet to open the Protect Sheet dialog box.
2. Select the required options.
3. Enter a password in the Password (optional) text box to prevent unauthorized users from removing sheet protection.
4. Click OK to open the Confirm Password dialog box.
5. Enter the same password in the Reenter password to proceed box.
6. Click OK.

How to Password Protect Part of a Worksheet:

1. Select the range of cells that you want users to be able to modify.
   • The rest of the cells will be protected.
2. From Format menu choose Cells to open the Format Cells dialog box.
3. Click on the Protection tab.
4. Enter a password in the Password (optional) text box to prevent unauthorized users from removing sheet protection.
5. Clear the locked check box to unlock the selected range of cells.
6. Click OK to close the Format Cells dialog box.
7. Optional: Protect the password following the steps given above.