Home  >  Article  >  Topics  >  How to encrypt Excel tables

How to encrypt Excel tables

藏色散人
藏色散人Original
2019-06-03 11:19:0324909browse

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

How to encrypt Excel tables:

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

How to encrypt Excel tables

Select "Save As" and click "Browse".

How to encrypt Excel tables

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

How to encrypt Excel tables

#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.

How to encrypt Excel tables

After confirming the password, click "Save".

How to encrypt Excel tables

#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.

How to encrypt Excel tables

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.

How to encrypt Excel tables

# "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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn