![]() And if you need to change, you can also change here. In the “Refers to Cells”, the content will already there because you have selected the target area before.Now input the certain name into the “Title”.And then in the new window, click the button “New”.Under this tab, click the button “Allow Users to Edit Ranges”. ![]() Set Password for Certain Rangeīefore you protect the worksheet, you may follow the steps below. So here you can make some extra settings to allow them to modify their own sale volume. The numbers are all correct except Paul and Sophia, and they need to change their sales volume. For example, in this file, you need those sales representatives to check their sales volume. But sometimes you need to send this file to other people, and they will modify certain area. And you may refer to it to see how it works: How to Protect Your Excel Worksheets with Passwords. In our previous article, we have talked about protecting worksheet. In addition, we will show you how to edit specific ranges in a protected worksheet. The protected worksheet can protect data security very well. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |