How does excel protect worksheets? Excel worksheet encryption method

1. Open the excel file that we want to protect first. I will not talk about the name or anything shown in the following figure. You can set it on your own.

2. Then, in the open cxcel file, click "Review"-"protect worksheet" and click it, as shown in the following figure.

3. when we click "protect worksheet", a "protect worksheet" will pop up, and the password we use when "disable worksheet protection:" is entered below, for example, enter a 123

 

4. After confirming, we will need to re-enter the password again, so as to ensure that the password is entered incorrectly once.

5. Now, if you open the excel file and modify the table, you will find that the excel file cannot be modified, as shown in the following figure.

6. If you want to modify the password, you can also click "Review" -- "undo worksheet protection" on the menu, as shown in the following figure.

7. Then, in "undo worksheet protection", we enter the password "OK" to cancel the protection function.