Protect a worksheet with or without a password

You can protect a worksheet in Excel to prevent others from editing its contents — and you can do it with or without a password.

Here’s exactly how to do both:

✅ Protect a Worksheet (Without or With a Password)

🔒 Step 1: Open the Worksheet You Want to Protect

1. Click on the worksheet tab you want to protect.

🔐 Step 2: Apply Protection

1. Go to the Review tab on the Ribbon.
2. Click Protect Sheet.
3. In the Protect Sheet dialog box:
   • ✅ Choose what users are allowed to do (e.g., select cells, format cells, insert rows, etc.).
   • 🔑 Optional: Enter a password if you want to prevent unauthorized unprotecting.
4. Click OK.
   • If you set a password, Excel will ask you to confirm it by typing it again.

🧯 To Remove Protection

1. Go to the Review tab.
2. Click Unprotect Sheet.
   • If there’s a password, you’ll be prompted to enter it.

⚠️ Notes

• If you don’t use a password, anyone can unprotect the sheet.
• If you forget the password, it cannot be recovered easily — make sure to store it securely.
• Protecting a sheet does not encrypt or hide data — it only prevents editing of cells, formulas, or formatting.

🧠 Want to Lock Only Certain Cells?

1. Select the cells you want to remain editable.
2. Press Ctrl + 1 → Go to Protection tab → uncheck Locked.
3. Then protect the sheet as described above.
   ✅ Now only the other (locked) cells will be protected.