Protect Worksheet in Excel

When you share an Excel file with other users, you may want to protect a worksheet to help prevent it from being changed. Using this option, you can lock your Excel sheet with a password and you can make only certain parts of the sheet editable and users will not be able to modify data in any other region in the sheet.

Preview in new tab

1. How to Protect Sheet in Excel ?

Steps:-

• Right click on sheet tab > Click Protect Sheet. Or Home> Format > Protect Sheet

• Check on protect worksheet and content of locked cells box.
• Enter a password.
• Check the actions you allow the users of your worksheet to perform.
• Note:- if you don’t check any action, users can only view the Excel file.
• Click OK.

• Confirm the password and click OK.
• Your worksheet is protected now.

2. How to Unprotect Sheet in Excel ?

• Right click on sheet tab > Click Unprotect Sheet. Or Home> Format > Unprotect Sheet.

• Enter Password
• Click Ok
• Your worksheet is unprotected now.

• Share on Facebook
• Share on Twitter
• Share on Pinterest
• Share on LinkedIn
• Share via Email
• Share on Tumblr
• Share on Reddit