In order to protect the security of Excel files and prevent others from viewing the data contents of the forms at will, it is necessary to set an open password for Excel forms. People who do not know the password cannot open the files to view. This article will teach you how to set an open password for Excel forms, and can also set passwords for multiple files in batches. A detailed graphic operation tutorial is attached for you to learn.
Excel table settings open password effect preview
Batch to Excel Set Open Password Steps
1, open. HeSoft Doc Batch Tool , select Excel Tools → Excel Add Password Protection.
2. Add files or import files from folders to add Excel that needs to set passwords.
3. Check the file opening password and enter the password to be set below.
4. After the processing is completed, click Save Location to view. All Excel files have been set with passwords. To open a file at will, you must enter a password to view the contents.
in addition to the above method, you can also set the opening password directly in Excel. Click File → Information → Protect Workbook, select to encrypt with password, then enter the password to be set, and then confirm.
This method is more convenient, direct, and does not require the installation of other software. However, only one Excel file can be encrypted at a time, and cannot be operated in batches. It is only suitable for encrypting a small number of files.
in addition to setting an open password for Excel tables, you can also use other encryption methods to protect files.
For example, if you set a worksheet protection password, others can only view the table and cannot modify and edit any cells in the table. There is also a password to protect the workbook structure, which does not allow others to add or delete worksheets inside. In short, you can set different password protections for Excel according to your needs.
If you want to remove the password protection of the Excel table and allow anyone to view the file, you can also use HeSoft Doc Batch Tool to batch cancel the password. Select Excel Tools → Excel to remove password protection.