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 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.

HUGE LIMITED TIME DISCOUNT ON THE BEST ADVANCED EXCEL COURSE ENROLL NOW!!
excel_look_professional
Making Excel Worksheets Look Professional – A Case Study
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
FREEZE PANES
Freeze Panes in Excel – The Complete Guide
HOW TO LEARN EXCEL
How to Learn Excel and Be a Spreadsheet Champion
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
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
Pivot Tables
How To Convert Pivot Table Into Frequency Distribution
How to Convert Pivot Table into a Frequency Distribution in Excel

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.

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