Sometimes an excel worksheet may contain sensitive data and information and you may not want the users of the spreadsheet to edit the information. Excel allows you to protect the worksheet after which the users will be able to view the data, but will not be able to edit the same (depending on what powers you allow them).
Protect a Worksheet
So let’s learn how we can protect an excel worksheet with passwords. Follow the steps given below:
1. Right-click on the name of the worksheet you want to protect.
2. Click on ‘Protect Sheet…’.
3. Enter a password to be used to unprotect the sheet.
4. Check the powers you want to allow to the users of the worksheet. (Note that if you don’t check any of the actions, the users will just be able to view the sheet)
5. Click OK
6. Confirm the password and click OK
Your sheet will now be protected.
Related Post: How to Lock And Unlock A Cell In An Excel Worksheet
Unprotect a Worksheet
To unprotect a worksheet, right click on the worksheet name and click ‘Unprotect Sheet’. Then enter the password and click OK.
Now your sheet will be unprotected and open to edit.
Hope you enjoyed today’s lesson. Please leave a comment if you liked the video and the post. Also, please feel free to share your suggestions and feedback on this post or about madaboutexcel.com as a whole.
I also have a couple of small requests. Please follow Mad About Excel on social media to remain updated with all the latest videos that we share.
YouTube: Click here to go to Mad About Excel YouTube channel.
FaceBook: Click here to go to Mad About Excel on Facebook.
Twitter: Click here to go to Mad About Excel on Twitter.
Also, please subscribe to the Mad About Excel newsletter by submitting your email id in the relevant form right under this post.
Have a great day. Happy Excelling!!
GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE
Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!
Thank you for subscribing.
Something went wrong.