How to encrypt Excel tables

Some Excel tables are only allowed to be viewed by specific people. In order to avoid being accidentally seen by other unrelated people, the table needs to be encrypted. The following steps will be introduced in detail, and these steps are also applicable to Word.

How to encrypt Excel tables:

First open the table that needs to be encrypted and click "File".

Select "Save As" and click "Browse".

Open a table storage path, enter the file name, and click "General Options" under "Tools".

#You will see the following window, which requires the input of "open permission password" and "modify permission password". Once a password is set, you must enter the correct password before you have permission to perform corresponding operations. "Open permission password" refers to the password that needs to be entered when opening this Excel form, and "modify permission password" refers to the password that needs to be entered when modifying this Excel form.

After confirming the password, click "Save".

#Look, when you double-click to open the Excel table, the password input box pops up. This requires you to enter the correct password to see the form content.

Since the "modify permission password" is also set, after entering the opening password, you are prompted to enter the modify permission password or open in read-only mode.

# "Open permission password" and "Modify permission password" can only be set as needed. After setting a password, be sure to remember it.

In addition, in addition to directly encrypting documents, you can also protect data by encrypting the data.

The above is the detailed content of How to encrypt Excel tables. For more information, please follow other related articles on the PHP Chinese website!