method

1186Currently online
10Today's Reading
20Share Today
Multilingual display

How does excel Partition lock a worksheet

2018-04-26 09:36:38

In our daily work, we use excel for document storage or computation, and data security becomes very important. Today, I want to show you how to partition lock worksheets in excel to protect data security.

Tools/Materials
1

A computer with excel software (Excel 2007)

2

An excel sheet with a record of your grades (this is just an example)

Methods/Steps
1

Related content learned from experience

2

Next, we select the Review - Allow the user to edit area in the menu bar (because the editor uses excel2007), the specific location is shown in the appendix image

3

Next, you need to click the "" button in the" Allow users to edit Areas "dialog box that pops up. The interface is shown as follows:

4

After clicking "", the" New Zone "dialog box will pop up. All you need to do is enter the title name in the text box below the title, such as Test Area A, then enter the area password and click OK

5

After clicking OK, an interface will pop up, "re-enter password", which is a way of password verification, that is, to confirm the password.

6

By analogy, select the "E:H" cell area and repeat the operation in the above method to lock the cell area, as shown in the following figure.

7

Then, return to the "Allow users to edit areas" dialog box, click the "Protect sheet" button, the following interface appears, enter the password used to disable the sheet protection, and finally click OK.

8

Finally, our sub-zone lock is complete, now we just set the input in the partition, will pop up the "Cancel the lock area" dialog box, input the correct password can be modified, the interface is as follows.

9

Congratulations, you have successfully completed the zone lock worksheet, ensuring the security of your data!

Matters needing attention
1

Never forget your password after setting it

2

The password must be the same before and after the two times, because it is the way to confirm the password

Recommendation