There are times when we want to protect Excel sheet while sending the information to other department or within the department, as we don’t want anybody to disturb (change, edit, delete) the information present in the sheet.
Excel provides the easy solution to lock the entire sheet and preventing the accidental damage or the tempering of the information present in the cells.
Protecting the worksheet
There are 2 ways to protect the sheet in Excel 2016, 2013 and 2010, perform the following steps:
The process is shown in the following spreadsheet:
When you click the Protect sheet option, a dialog window will open asking for the password to protect the sheet as follows:
(*When you create the password for the sheet the Protect sheet button automatically changes to Unprotect sheet button)
Selecting the actions, you want the users to perform in your sheet, in the protect sheet dialog box:
When someone tries to modify the sheet, the following message will appear:
“The cell or chart you’re trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password.
Unprotecting the worksheet in Excel
As you have seen above that it is quite easy and Excel offers two ways to protect the work sheet. It is even easier to unlock as Excel provides multiple ways to do it.
Remember, you will always need a password to Unprotect the sheet.
Upon pressing the Unprotect Sheet button using any of the above ways, the new dialog box is opened and you are prompted to enter the password to unprotect the sheet.
On entering the password, press OK and the sheet is unprotected and you can edit it.
I have used the way 1 to unprotect the sheet shown in the above screenshot which is as follows:
The worksheet protection in Excel is not actually a security feature as it uses a very simple algorithm and anyone having the basic knowledge of VBA can break it easily.
It is a feature which is used to avoid any accidental loss of information by you or your team members.