The protected worksheet can protect data security very well. In addition, we will show you how to edit specific ranges in a protected worksheet.
In our previous article, we have talked about protecting worksheet. And you may refer to it to see how it works: How to Protect Your Excel Worksheets with Passwords. But sometimes you need to send this file to other people, and they will modify certain area. For example, in this file, you need those sales representatives to check their sales volume.
The numbers are all correct except Paul and Sophia, and they need to change their sales volume. So here you can make some extra settings to allow them to modify their own sale volume.
Set Password for Certain Range
Before you protect the worksheet, you may follow the steps below.
- Click the target range. And here we click C2.
- And then click the tab “Review”.
- Under this tab, click the button “Allow Users to Edit Ranges”.
- And then in the new window, click the button “New”.
- Now input the certain name into the “Title”. Here we input “Paul”.
- In the “Refers to Cells”, the content will already there because you have selected the target area before. And if you need to change, you can also change here.
- Input the password into the “Range password” text box.
- Next click “OK”.
- In the “Confirm Password” window, input the password again.
- And then click “OK”.
- If you want to leave the permission in a new worksheet in case you will forget, you can check the option “Paste permission information into a new workbook”.
- And then click the button “Apply”.
- Next click “OK”.
Thus, you have finished the setting of the target cell. You can also repeat the steps to set password for the sales volume of Sophia. In addition, you can also set the two cells together. All the setting should be adjusted according your actual requirement.
- And then you can protect the worksheet with another password.
Edit Certain Range
Now you have sent the file and the corresponding password to Paul. And if John needs to modify the number, he may input the password first.
- Double click the cell.
- Then input the password into the text box.
- Next click “OK”. Thus, this cell can be edited. However, without the password of the worksheet or other range password, Paul cannot modify other cells.
Excel Disaster can Damage your Password
Even if you have set password to your Excel worksheet, it can also be damaged in a data disaster. As a result, your important data and information will leak. To avoid such accident, a third party Excel recovery tool can help you. It can get back almost all the information in your file within minutes.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com