Locking cells can be beneficial, especially when two or more people are working on the same spreadsheet. However, sometimes you must protect your entire worksheet from being edited. In other cases, you must unlock cells or ranges in the protected worksheet. So, keep reading because this article will teach you how to do all of these!
Protecting an entire worksheet in Excel can be easy since all cells are locked. You only need to:
Like locking a cell, this command will open a pop-up window that asks you to type a password to unprotect it, so remember to choose the one you can remember because there is no way to reset it.
Once you have it, in the dialog box where you put the password, you can warrant some actions like sorting, formatting, etc. If you don’t enable them, the operations won’t be allowed to use them.
In the same pop-up window, in the “Allow users of this worksheet to” checkbox list, you can also see that the “Select locked cells” and the “Select unlock cells” options are already marked. This means that everyone who has access to the protected worksheet will be allowed to click on the cell to observe the content and formulas but won’t be able to change them. Afterward all above, here you have some other considerations:
Of course, let's make the contrary case: you've received a locked worksheet, and you ought to edit it. So the first thing you must know is if the sheet has a password. If so, you just need to type it and click "OK" to unlock it.
In case of having several protected worksheets in an Excel Workbook, you must follow the steps below:
Note: You must enter the password for each sheet you want to unlock.
Editing specific ranges:
There are some situations where you can permit different people to edit particular cells than others. To add separate passwords to ranges in a worksheet, you just need to follow the steps below
After that, you will return to the "Allow Users to Edit Ranges" dialog box, so you must repeat the steps to the three (3) to nine (9) processes with the new ranges and a new password.
Don’t forget to protect the sheet when you’re done because remember that locking cells or ranges have no effect unless the worksheet is protected. After that, type a standard password for the worksheet, and pass it with the specific password of the range to the people you need to edit it.
Next to “Protect Sheet,” you can find the “Protect Workbook” option, which doesn’t affect the lock or unlock cells or ranges operations. This command will prevent users from making structural changes like moving sheets, hiding, deleting, and adding columns or rows unless they put in the password to make them.
This is a method by which you can lock the entire file so that users must put the password to view the content. To do this, you just take the following steps:
Now anyone must put the password to open the file, and if you received a protected worksheet, make sure to have the corresponding passwords.
There you have it! There are many ways by which you can protect your data, just try them yourself and find what you consider fits you better.