How to make Excel Encryption Worksheet

Excel encryption function has a great effect on the protection of personal data, so the system home Xiaobian specially sorted out an article to introduce how to use Excel's built-in encryption function to encrypt the Excel worksheet and prevent others. Modify the write. When editing Excel, please execute the "File" → "Save as new file" in the menu, then select "Tools" &rarr in the upper right corner; "General Options" will pop up a password for us to enter "Protect Password" and " The anti-write password window is described as follows: - Protection password: When you want to open Excel, you need to enter the correct password to see the contents inside; - Anti-write password: After opening Excel, you need to enter the correct password. Only have the right to modify the contents; basically we can choose the function you want to input, you can choose one or both, there is no special rule; suppose we both input well, then Excel will jump out Confirm the password window, let us confirm that the protection password and anti-write password are correct. After setting the password, you can archive it. When the new file is opened next time, you need a password to view the content. If you have a password to write, you need to enter the correct password to edit the file. The anti-writing function does not have any effect, because the user can directly press "read only" and then save another file. Therefore, I think the setting of the anti-writing password is ineffective. It is important to know how to set the password. "Yes."