Setting the workbook password for Excel2010 is set in the information selection in the file button. The password for other versions of Excel workbooks can be set in the "Protect Workbook" option under the file options. .
Set workbook password:
1. Click the "File" tab.
#2. Then click the "Protect Workbook" button.
3. In the pop-up drop-down menu, select the option "Encrypt with password".
#4. After that, enter the required password in the "Encrypted Document" pop-up box. There is also a reminder here that letters are case-sensitive.
#5. After entering, click "OK", and then enter the password you just set in the "Confirm Password" window.
The above is the detailed content of How to set workbook password. For more information, please follow other related articles on the PHP Chinese website!