In the case of a protected Excel worksheet, in order to protect some structures and formulas of the table from misoperation, it is a common method to set the save password of the worksheet. However, over time, the Excel we have accumulated for a long time gradually becomes huge. Excel with the worksheet password added will become an obstacle to our subsequent opening of the file for inspection or use. Repeated password input will seriously reduce our work efficiency.
So how do we address a pain point problem to quickly remove the restriction protection of a large number of worksheets? Here is an efficient technique to help us easily remove the restriction of worksheets in batches, let the data resume editing, and make the entire Excel table more flexible!
Under what circumstances do you need to delete all Sheet protection passwords for easy-to-use people to modify cells?
1. When Excel files are shared and collaborated with team members, deleting the protection passwords of all Sheet can facilitate members who do not know the passwords to modify the cells, and the office efficiency will be greatly improved without the operation of repeatedly inputting passwords.
2. For Excel files that need to be checked and updated regularly, deleting the protection password of Sheet can reduce the efficiency of staff in opening files, facilitate maintenance personnel to quickly update data and optimize the operation process.
3. When the contents of Excel worksheet change from privacy to public, the management personnel can delete all the restricted passwords of Sheet on the premise of knowing the passwords. For example, a template form that can only be used internally needs to be shared with external partners. In order to facilitate the other party to fill in, we can cancel all worksheet passwords.
Delete Xls, Xlsx in all worksheet password effect preview
before treatment:
after treatment:
Batch empty Excel file in all worksheets limit password operation steps
1. Open 【 HeSoft Doc Batch Tool ], select [Excel Tools]-[Excel Delete Password Protection]].
2. Select a method to add Excel files that need to delete worksheet passwords in [Add Files] or [Import Files from Folders]. It also supports dragging files directly into the addition, and then click Next.
3. Enter the option setting interface, enter the Excel restriction password in the [Worksheet Restriction Password] at the bottom, and then click Next again. Then click Browse and select a location to save the new file.
4. Wait for a few seconds to complete the processing, click on the red path to open the folder, and you can see the Excel form with the password deleted successfully!
