In our daily work, in order to prevent others from misoperating or modifying the data content without authorization, we will need to set up protection for multiple Excel workbooks in a unified way. As a widely used spreadsheet tool, Excel is suitable for processing data such as financial statements and statistical reports. However, in general read-only mode, Excel can be modified at will. All cells can be edited, which is not conducive to our protection of important data.
In this case, how should we go to open the worksheet protection to lock the cell, allowing to view at the same time, efficient to prevent the table data is changed? This article to introduce a batch of methods to prohibit the modification of Excel tables, by adding restrictions on the password, effective protection of the user's file data, let's try to see it!
Excel table opening limit does not allow to modify the effect preview
after treatment:
Batch to Xls, Xlsx Add Read-Only Restricted Password Steps
1. Open 【 HeSoft Doc Batch Tool ], select [Excel Tools]-[Excel Add Password Protection]].
2. Select a method from [Add File] or [Import File from Folder] to import Excel forms that you do not want others to modify, or drag them into the following to add them. After confirming that there is no problem with the files, click Next.
3. Enter the setting option, open the [Restrict editing password] button, select read-only type, enter the password to remove the restriction below, and finally click Next again. Then click Browse and select a location to save the new file.
4. After waiting for the processing to be completed, click the red path to open the folder to view the Excel file with the password added successfully.
Excel Add Read-Only Password and Add Restricted Password Difference between
Add Read-Only Password Function and Characteristics
in Excel, after adding a read-only password, the user can still modify the content when opening the file, but it is forbidden to save directly to the original file. When the viewer enters a read-only password to open the file, although the contents of the cell can be changed, the file can only be saved as a new file by using Save As, and the original file cannot be overwritten. This method usually protects the original file from being modified when the file needs to be viewed by others, so as to avoid missing data caused by misoperation.
Add restrictions password role and characteristics
unlike ordinary read-only passwords, setting a limited read-only password can directly lock the contents of the file, which makes it impossible to make any changes to the cell. Usually we usually turn on the worksheet protection function, we need to set the protection worksheet in the file properties, and then add a password to restrict the modification permission. When opening the file, all cells will be locked and cannot change the content unless the correct password is entered to unlock. Compared with read-only passwords, restricted passwords provide higher security, not only preventing misoperation, but also effectively preventing files from being modified by others. It is the best choice to protect data.