we have organized the data report, in order to prevent others from mistakenly changing the contents, we need to protect the worksheet, lock all cells, and prohibit editing and modification. There are several ways to encrypt Excel tables: HeSoft Doc Batch Tool , Excel's protected document function, Google Sheets permission settings. Here's a detailed description of the advantages and disadvantages of each method and the specific steps.
Under what circumstances do you need to set a password for an Excel table?
1, the document does not allow anyone to change
the data and reports that we have already done need to be sent to leaders for review or shared with colleagues. In order to prevent others from modifying the data in them by mistake, Excel forms must be encrypted. Setting the worksheet limit editing password allows others to view the contents of the file freely, but cannot make any changes to the contents of the cell.
2. Final locked version before submission
all the data in the Excel table has been reviewed and the final version has been formed. Therefore, it is necessary to set a password for the table to restrict editing. Everyone can only view the table data and cannot make any adjustments.
3. Share files with people who are not familiar with Excel
if we want to send Excel forms to colleagues, customers or other people who are not familiar with Excel, after adding a restricted editing password to the form, we can prevent them from confusing the data in the form, deleting them by mistake, etc., and reduce the operational risk.
Preview of the effect of preventing editing of Excel files
method 1: Use HeSoft Doc Batch Tool Batch encryption for Excel
recommended Index:★★★★★
Advantages:
- you can set a variety of password types such as open password, read-only password, limited editing password for Excel files.
- Support batch processing, can give hundreds of Excel files a key encryption, no manual operation, very convenient.
- The operation is simple, without any difficulty, just add all the files and select the password type for encryption.
- It can also set passwords for various file types of Word, PPT and PDF synchronously to meet various encryption needs of users.
Disadvantages:
- it needs to be installed on the computer.
Operation steps:
1. Open 【 HeSoft Doc Batch Tool ], select [Excel Tools]-[Excel Add Password Protection]].
2. Next, add all the Excel files that need to be encrypted. Click to add files or drag and drop directly.
3. Select [Restrict Editing Password]-[Protect All Worksheets] and fill in the password to be set below.
4. After the processing is completed, click on the save location to view, and all Excel are encrypted.
Method 2: Protect worksheet with Excel's Protect Document feature
recommended Index:★★★☆ ☆
advantages:
- the operation steps are simple and direct. If you find the function of protecting the workbook directly in Excel, you can add a password to the file.
- It is very convenient to use and can handle temporary and urgent encryption needs in a few seconds.
- If there is no network, you can also set a password for the file, which is more suitable for the working environment of the intranet.
Disadvantages:
- manually encrypt files without batch processing. When there are many files, it is very time-consuming and labor-intensive.
Operation steps:
open the Excel file to be encrypted, click [File]-[Information], find [Protect Current Worksheet] in the protected workbook, fill in the password and confirm it again, and click OK to complete the encryption.
Method 3: Set View Permissions for Excel with Google Sheets
recommended Index:★★★☆ ☆
advantages:
- can be set to Excel viewer, editor, commentator permissions, the file editing permissions to the individual.
- Only the specified area of the form can be locked and the area allowed to be filled in can be opened. The formula area and the header area can be permanently protected.
- There is no need to set a password, and the permission can be recovered at any time, which can avoid the error of the password being forwarded, and the confidentiality is stronger.
Disadvantages:
- Excel files can only be shared online. After the file is downloaded locally, the encryption will be invalid.
Operation steps:
1. Open Google Sheets, make forms online, or upload files from your computer to Google Sheets.
2. Click [Share] in the upper right corner to add the person or group to be viewed, select [Viewer] in the permission on the right, and click Finish.
