we use Excel to produce some financial statements, budget tables and other documents, which contain important data, can only be reviewed by specific people. In order to prevent others from opening the file to view at will and avoid data leakage, you need to set an open password for Excel files. If we have a lot of Excel tables to set an open password, we can use the following 4 methods to batch encrypt: HeSoft Doc Batch Tool Excel plug-in, compression software encryption, VBA macro script.
Under what circumstances do you want to set open passwords for Excel in batches?
1. A large number of Excel reports generated by the finance department, the data in which relate to the company's core financial information, cannot be seen by others. Therefore, it is necessary to set the opening password uniformly, which can only be viewed by oneself or the management, and others have no access.
2, the company's Excel project documents, such as project budget table, cost accounting table, customer requirements list, etc., these documents are also business secrets. After the project is completed, set passwords for these files in batches and then archive them, which can effectively prevent others from viewing the files.
3. When we send Excel forms to leaders or customers, it is easy to cause information leakage during the transmission process, allowing some irrelevant personnel to see the contents of the files. In order to keep the data confidential, we need to set open passwords for Excel tables in batches and only open passwords for designated people, so that others cannot view files without knowing the passwords.
Excel has set a preview of the effect of opening the password
method 1: Use HeSoft Doc Batch Tool One-click batch encryption
recommended Index:★★★★★
Advantages:
- the operation method is very simple. We only need to import all Excel files and set the password type, and it will automatically encrypt all files without any difficulty.
- For real batch processing, we can import hundreds of Excel files at one time, and encrypt them with one key, saving time and effort.
- You can set multiple password types such as open password, read-only password, and restricted editing password for Excel in batches.
- Support Chinese, English, French, German, Spanish, Japanese, Korean and other languages.
Disadvantages:
- it needs to be installed on a computer and only supports Windows systems.
Operation steps:
1. Open 【 HeSoft Doc Batch Tool ], select [Excel Tools]-[Excel Add Password Protection]].
2. Click to add files or import files from folders to add all Excel tables to be encrypted, supporting xlsx, xls, xlsb, xlsm, xlt, xltx, xltm, csv, numbers and other file formats.
3. Select [File Open Password] and fill in the password to be set below. It is recommended to use a combination of alphanumeric numbers and set the password length to medium length, so that the encryption effect is better and the password can be prevented from being easily cracked.
4. After the processing is completed, click the save location to view. There are locked Excel files in it. You must enter a password to open it.
Method 2: Use Excel Add-in Kutools to batch encrypt files
recommended Index:★★★★☆
advantages:
- Kutools plug-in is directly embedded in Excel, does not need to open another software, easy to operate.
- Simple and direct, select the encryption function of the plug-in, then add all the files, fill in the password and then automatically encrypt it.
- Function-rich, can be used for a long time, can help us improve work efficiency, suitable for users who often use Excel to work.
Disadvantages:
- paid plug-in, some functions will be limited by Excel version.
Operation steps:
1. Install the Kutools plug-in, click [KUTOOLS PLUS] and select [Encrypted Workbook]].
2. Click [Add] to add all the Excel files that need to be set to open the password, fill in the password below, and finally click [OK] to encrypt all Excel files.
Method 3: Use a compressed file to package Excel as an encrypted compressed package
recommended Index:★★★☆ ☆
advantages:
- without the aid of other tools, the computer comes with compression function, directly packs the file into a compressed package and sets the password, which is very convenient.
- The operation steps are simple, directly select the file, save it as a compressed package, and set the password. As long as there is a little computer foundation, it can be easily done.
Disadvantages:
- Excel files are not directly encrypted. Excel can be opened directly after the compressed package is decompressed.
Operation steps:
1. Right-click the Excel file to be encrypted, select [Add to Compression Package], fill in the password in the encryption column and confirm, and click [OK].
2. If there are multiple Excel files to be encrypted in batches, directly select all files, right-click [Add to Compression Package], and set the password.
Method 4: Use VBA macro script to batch set open password for Excel
recommended Index:★★★☆ ☆
advantages:
- Excel comes with VBA macro script function, no need to install other tools, directly in Excel can be operated.
- For real batch processing, the script can automatically identify all Excel files in the folder and set passwords in batches.
- Can be flexible to set the password, each Excel file can be set to open the password is not the same.
Disadvantages:
- the operation is difficult, the use of high threshold, not suitable for novice white.
Operation steps:
first put the encrypted Excel file into the same folder, then open Excel, press [Alt F11] to open the VBA editor, click [Insert]-[Module], paste the code, and then press F5 to run the VBA script.
