To protect the security of Excel files and prevent others from viewing the spreadsheet data at will, you need to set an open password for the Excel spreadsheet. People without the password will not be able to open the file and view it. This article will teach you how to set an open password for Excel spreadsheets, and how to batch set passwords for multiple files, with detailed illustrated operation tutorials for you to learn.
Preview of the Effect After Setting an Open Password for an Excel Spreadsheet
Steps for Batch Setting Open Passwords for Excel
1. Open HeSoft Doc Batch Tool , select Excel Tools → Add Password Protection to Excel.
2. Click Add Files or import files from a folder to add the Excel files that need password protection.
3. Check the File Open Password option, and enter the password to be set below.
4. After processing is complete, click Save Location to view. All Excel files have been set with passwords. Open any file at random; a password must be entered to view the content.
In addition to the method above, you can also set an open password directly in Excel. Click File → Info → Protect Workbook, select Encrypt with Password, then enter the password to be set and confirm.
This method is more convenient and direct, and does not require installing other software. However, it can only encrypt one Excel file at a time and cannot batch process, making it suitable only for encrypting a small number of files.
Apart from setting an open password for Excel spreadsheets, other encryption methods can also be used to protect files.
For example, setting a sheet protection password, where others can only view the spreadsheet but cannot modify or edit any cells within it; or setting a workbook structure protection password, which prevents others from adding or deleting worksheets inside. In short, users can set different password protections for Excel based on their own needs.
If you want to remove password protection from an Excel spreadsheet, allowing anyone to view the file, you can also use HeSoft Doc Batch Tool to batch remove passwords. Select Excel Tools → Remove Password Protection from Excel.