Course Content

Course Content


How to protect a MS Excel sheet with a password

Now we will see that how we can protect MS Excel sheet with password.

Now suppose in some cases we want our file to be protected and want whoever sees this file cannot edit anything inside it, so for that we will select the particular column and right click on it and select format cells option, inside which we will see protection column, in it we will select lock option.

After that we will go to our REVIEW tab, inside which we will see different options like a protect sheet and protect workbook, for now we will select protect sheet option and can see that one dialogue box will get opened in front of our screen.

According to our requirement we can select any option from that dialogue box, and then provide with a good password, after that it will tell us to re enter our password for confirmation.

As we do these we will see that, when we are going to click on our protected column we are not able to do it. We can't even select it or manage it in any way.

So this is how we have protected columns in our MS Excel sheet with a password.

Now to remove this option and unprotect everything we will go to our REVIEW tab and select unprotect sheet option, which will ask for our password we set. We can write it and and unprotect our file.


Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere