How to set up encryption for excel worksheet?

Setting method: 1. Click the "File" option; 2. Select the "Save As" option; 3. Click the "Tools" button in the "Save As" interface and select "General Options" in the drop-down box. ; 4. In the "General Options" interface, set the "Open Permission Password" and "Modify Permission Password" respectively, and check "Read Only" and click "OK"; 5. Click the Save button.

#If you don’t want others to see or open your worksheet, you can set a password for the worksheet to encrypt it. The following article will introduce to you how to set up encryption for excel worksheets.

Method/Steps:

1. Click the "File" option in the menu bar

2. Click the "Save As" option to pop up the save settings interface

3. Click the "Tools" button and select "General Options" in the tool drop-down list box

The lower version of EXCEL is directly the "Option" button.

4. In the "General Options" interface, set the "Open Permission Password" and "Modify Permission Password" respectively

5. After setting the password, and check "Read Only", click "OK" and a dialog box to confirm the password will pop up

6. Again Enter the password, which is the same as the "Open Permission Password"

After clicking Confirm, the "Re-enter Modify Permission Password" will pop up. After re-entering the same password as the previous password to modify the permission, click OK to close the dialog box

##7. Click the Save button to save the worksheet

8. At this time, find the saving directory, find the worksheet, and after opening the worksheet, a dialog box asking for a password will appear

The above is the detailed content of How to set up encryption for excel worksheet?. For more information, please follow other related articles on the PHP Chinese website!