Protecting Worksheets and Workbooks in Excel

Protecting worksheets and workbooks helps secure your data from accidental or unauthorized changes. Excel offers different levels of protection for both worksheets and workbooks.

---

1. Protecting a Worksheet

When you protect a worksheet, users can view its content but cannot edit locked cells.

Steps to Protect a Worksheet

1. Select Cells to Leave Editable (Optional):
   • Select cells that users should be able to edit.
   • Right-click, choose Format Cells, go to the Protection tab, and uncheck Locked.
2. Protect the Worksheet:
   • Go to the Review tab.
   • Click Protect Sheet.
   • Set a password (optional) and choose what actions users can perform (e.g., select locked/unlocked cells).
   • Click OK.
3. Test Protection:
   • Try editing locked cells to see the protection in action.

Example:

Product	Price
Apple	100
Orange	80

• Protect the sheet so only the “Price” column is editable.

---

2. Protecting a Workbook

Protecting a workbook prevents structural changes like adding, deleting, or rearranging sheets.

Steps to Protect a Workbook

1. Go to the Review Tab:
   • Click Protect Workbook.
2. Choose Structure Protection:
   • Enable Structure to prevent changes to sheet structure.
   • Set a password (optional).
3. Click OK.

Example:

A workbook contains sheets for Sales, Inventory, and Reports. Protect the workbook to ensure no one deletes or moves these sheets.

---

3. Allowing Specific Users to Edit Ranges

You can allow certain users to edit specific ranges within a protected sheet.

Steps:

1. Go to Review > Allow Users to Edit Ranges.
2. Select New and define the range.
3. Set a password or user permissions.
4. Protect the sheet as usual.

Example:

In a shared sheet, allow only the “Manager” to edit the “Price” column while protecting the rest of the sheet.

---

4. Encrypting the Workbook

To ensure the entire workbook is secure, you can encrypt it with a password.

Steps:

1. Go to File > Info > Protect Workbook > Encrypt with Password.
2. Enter a password and click OK.
3. Save the workbook.

Example:

You have a confidential financial report. Encrypt it with a password so only authorized users can open it.

---

5. Protecting Individual Worksheets vs. Entire Workbook

Feature	Worksheet Protection	Workbook Protection
Scope	Protects cell editing within a sheet.	Protects structural changes to the workbook.
Options	Lock/unlock cells, restrict formatting, etc.	Prevent adding, deleting, or moving sheets.
When to Use	When users need to interact with data safely.	When the workbook structure must remain fixed.

---

Important Notes

• Always remember passwords; they cannot be recovered if lost.
• Protecting a workbook or worksheet is not encryption. Use encryption for sensitive data.