Two methods to set and clear Excel opening password

php Xiaobian Yuzai introduces you two methods of setting and clearing Excel opening password. Password protection of Excel spreadsheets is an effective way to protect important information from being viewed or modified by others. But sometimes we may forget our password or want to cancel password protection. This article will introduce you in detail how to set and clear the password for opening Excel sheets, allowing you to easily deal with various situations.

Today we will talk about two methods of setting and canceling Excel opening password.

Set password method one:

1. Open the Excel table, click the [Information] option under [File] on the toolbar, and then click [Encrypt with Password] in the list under [Protect Workbook] on the right.

.

2. After the dialog box for entering the password pops up, enter the password you want to set, confirm it and enter it again. The password for opening the Excel table will be set.

.

Set password method two

1. Click the [Save As] option under [File] on the toolbar above the Excel table, and select the new path to save the modified file on the right. You can use the same path as the original, that is, overwrite the original file.

.

2. After the saving directory is confirmed, the [Save As] dialog box will pop up. Click [General Options] in the list under [Tools] in the dialog box.

.

3. A new dialog box pops up again. Enter the password you want to set in [Open Permission Password]. After confirmation, enter it again. The password to open the Excel table will be set.

.

Clear open password method one

If the Excel form has passed the protection period and there is no need to enter the password every time it is opened, that is, if we want to remove the "enter password" step, then we can also clear the original password.

No matter which of the above methods was used to originally set the password, you can follow the steps below to clear it.

First click on the operation path of opening the password according to the above two settings. Finally, the dialog box for setting the password will pop up, and you can see that the password already exists in the box.

You only need to delete the password in the box. After it becomes blank, click [OK] and the password will be removed. After saving, you no longer need to enter the password when opening the Excel file again.

.

Clear open password method two

The prerequisite for clearing the password in method one is that you need to know the originally set password. If you forget it, the file cannot be opened and the password cannot be cleared, and there is no password retrieval function in the Excel table.

At this time, you can use other tools to retrieve the password first, and then follow the above method to clear the password.

Similar tools, such as Pepsi Niu Excel Password Recovery Tool, select the [Retrieve Password] module in the tool, then import the Excel table into the tool, and follow the prompts.

PepsiNiu Excel Password Recovery Tool

After the operation is completed, wait until the password is retrieved.

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