Two methods to set Excel 'open password'

Are you worried about the security of important Excel files? Setting an "open password" is an effective means to ensure file security. PHP editor Apple has prepared two setting methods, which are simple and easy to understand, to help you easily protect your Excel treasure trove. Read on to learn how to make your Excel files bulletproof!

Method 1: Set in Excel

After opening the Excel table, click the menu tab [File], then click [Information] - [Protect Workbook] - [Encrypt with Password];

After opening the [Encrypted Document] dialog box, enter the password you want to set in the password field, click [OK] and re-enter it to set it.

As long as you open the Excel table later, a dialog box will appear, prompting that you need to enter a password to open the file.

Method 2: Set via "Save As"

We can also set the "open password" by saving the Excel table.

First, open Excel and save the table. After calling up the [Save As] dialog box, click the [General] option in the [Tools] option list;

After opening the [General Options] dialog box, enter the password you want to set in the [Open Permission Password] column, click [OK] and enter the password again, and then save Excel. You can save Excel as a new file. You can also directly overwrite the original file.

After saving, Excel’s “open password” will be set.

Cancel password:

Let’s take a look again. Can the password be canceled after setting it? We can look at it in two situations.

If you remember the password, you no longer need password protection, that is, you do not want to have to do the "enter password" step every time you open the Excel table. You can cancel it as follows:

First open the Excel table with the password, and then follow the operation path to set the password to bring up the password dialog box. Whether you use "Method 1" or "Method 2" to set the password, you can see it in the password column. For the originally set password, you only need to select and delete the password, turn it into a blank column, and then save the Excel to cancel "Open Password".

Password field for method 1:

Password field for method 2:

Let’s talk about the second situation. If you accidentally forget your password, you cannot use the above method to cancel the password, and there is no "Forgot Password" related option in the Excel table.

In this case, we need the help of other tools.

For example, the Pepsi Niu Excel Password Recovery Tool used by the editor, the [Retrieve Password] module in the tool can help us retrieve the "Open Password" of Excel.

After selecting the [Retrieve Password] module, you can see that there are 4 retrieval methods above.

We only need to import the Excel table into the tool, then select the appropriate method and follow the prompts.

The above is the detailed content of Two methods to set Excel 'open password'. For more information, please follow other related articles on the PHP Chinese website!