How To Protect and Unprotect an Excel Worksheet

Published on January 8, 2017
image_pdfimage_print

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 Worksheetprotect 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 ULTIMATE EXCEL SHORTCUTS COURSE
worth $40 for FREE!!

Subscribe to our newsletter and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

Huge Discount on the Best ADVANCED EXCEL Course. GET IT NOW!! CLICK HERE!!
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
BECOME AN EXCEL NINJA COMPLETE REVIEW
Become An Excel Ninja – Course Review
BEST EXCEL COURSES
10 Best Online Courses to Make You an Excel Wizard
HOW TO GET MY $40 COURSE FOR FREE
Get My $40 Excel Course For Free!! COUPON CODE Inside!!
14 Excel tips
14 Excel Tips – Make Yourself Super-Efficient in Excel
DATA CLEANING EXCEL
Ultimate Guide to Data Cleaning in Excel – 11 Super-Powerful Data Cleaning Techniques
RANDOMIZE LIST RANDBETWEEN
Randomize a List in Excel Using RANDBETWEEN Function
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
How to Sort Excel Worksheet in Alphabetical Order
How to Sort Excel Worksheets in Alphabetical Order
VBAPOST1
How to Add And Name A New Sheet At The Same Time Using Excel VBA
ROUNDING NUMBERS IN EXCEL
Rounding Numbers in Excel – The Complete Guide
number_of_words
How to Find the Number of Words in a Text String in Excel
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
How To Indentify ULP case in a text string
How To Identify If A Text String Is In Upper, Lower Or Proper Case
How To Change Shape of Comment Box in Excel
How To Change The Shape Of Comment Box In Excel
Excel Dumbest Challenge
Excel Dumb Challenge – Do You Have Time To Waste?

Get my ULTIMATE EXCEL SHORTCUTS COURSE
worth $40 for FREE!!

Thank you for subscribing.

Something went wrong.

Share
Tweet
+1
Pin
Share
Stumble
Enjoyed this video?
protect worksheet
"No Thanks. Please Close This Box!"