Excel2007 How to set read-only encryption properties to protect data security

When making some reports and company tables, we often need to encrypt Excel tables or set them as read-only properties to protect these important tables. Encrypting a table prevents others from opening the table, and only opens it correctly by typing the correct password. When set to read-only, you can prevent others from modifying the file, only reading the table, unless you enter the correct password to modify the contents of the table. Excel encryption Technique 8844 has been introduced before, today to explain how the next Excel2007 to the table to set the read-only property!

1, in Excel2007 Click Office Button, in the pop-up menu bar, select "Save As" in the "Excel Workbook" command;

Excel work Thin

2. Click the triangle button next to "Tools" in the lower left corner of the "Save as" window that pops up and select "General Options";

General Options

3, at this time will pop up a "General Options" dialog, we can see that there are two password permission settings, if you want to encrypt the form we can in the "Open password" after the password, then we open the form must enter the correct password before you can read the form. Here we select "Modify password" to enter the password in the following, and then "recommended Read-only" check, and then confirm, and then in the pop-up "Confirm password" re-enter the password just entered;

Modify Permission Password

Confirm Password

4, finally click the "Save" button.

Please enter a password to get write permission or open as read-only

The above is the specific operation of how to set the table to read-only in Excel2007, and then when we open the table again we are prompted "Please enter a password to get write permission or open as read-only." ”