How to encrypt Excel tables

Office software is perfect for security because it's office software, so it's often possible to design company secrets and privacy. Therefore, Microsoft in the development of each version of Office will have the ability to encrypt files, previously mentioned word encryption techniques, we remember. Let me tell you today how to encrypt Excel forms. Many netizens may have already, but in order to help some just get started friend I still want to mention!

Excel2003 Table Encryption method

When you enter Excel, click Tools on the menu bar. Then select the bottom of the "Options" button, in the pop-up "Options" window, we choose "Security", at this time, we can "open password" after the box to enter the password, and then press the OK button, and then re-enter it again.

Excel Tutorials

Tip: There are two keys to setting a password

The first item: "Open permission password" means that if you save the form password, you must enter a password to open the preview or modify the form.

The second item: "Password to modify" means that after the password is set, we can preview the reading of the table, but can not modify it to save, if modified to save as a copy.

Encryption method in Excel2007 table

Open Excel2007, click the Office button in the upper-left corner, and then select Prepare to encrypt the table by clicking "Encrypt document" in the pop-up list.

OK, now from Excel2003 to Excel2007 two different versions of the encryption method has been told everyone, hope to help. Originally said to demonstrate the Excel2010 encryption method, but because I did not install the machine Excel2010, so there is no way, next time to tell you!