Excel is a fully functional spreadsheet software, in Excel there are two concepts of workbooks and worksheets. A workbook is the whole of an Excel file, a worksheet is a single sheet page, and a workbook consists of multiple sheet worksheets. If we want to prevent others from adding or deleting sheet sheets in a workbook, you can set a limit password to Excel, lock the whole workbook structure.
Excel workbook structure locked after effect preview
before treatment:
after treatment:
Batch to Excel Set Workbook Limit 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. Select Restrict Editing Password → Protect Workbook Table Structure, and fill in the password to be set below.
4. After the processing is completed, click Save Location to view. All Excel have set the workbook restriction password. When you right-click sheet, you cannot select functions such as insert, move, delete, and rename.
Excel workbook password and worksheet password in
1. The workbook is a whole, and the worksheet is a single table page. Setting a workbook password is mainly to prevent the structure of the entire workbook from being changed, such as moving, deleting, renaming, or adding worksheets inside. After the workbook is password protected, the entire structure is locked and none of the above operations can be performed.
2. Set a password for the worksheet to prohibit others from editing and modifying, mainly to prevent the data in the table from being changed. After the worksheet is set with password protection, all cells in the current table are not allowed to be edited. You will be prompted that the cell is located in the protected worksheet and you must enter a password to edit it.
Excel file a total of several kinds of password type
open password: protect the entire Excel file, prevent others from viewing the contents of the file at will, the highest level of protection.
Read-only password: Protects the entire Excel file, allowing only the file to be viewed, but not to make any edits to it.
Restrict Edit Password (Workbook): Protects the Excel workbook structure and prevents others from inserting, deleting, or rearranging worksheets.
Restrict editing password (worksheet): Protect the data content in the worksheet and prevent the data in the table from being edited and modified.