Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
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.
Have a friend to whom you would want to share this course?