How to unprotect a worksheet if you forget your protected password in excel

How to unprotect a worksheet if you forget the excel protection password:

The first step is to find an Excel worksheet with a worksheet protection password, and then The suffix name is changed to .rar.

The second step is to open the compressed file and find the corresponding path of the compression.

The third step is to drag the .xml file found from the compressed file and modify it.

The fourth step is to delete the protection code to unprotect the worksheet. Find the .xml file and open it with Notepad, then search for [protection] and change the name from All codes are deleted, as shown in the figure.

The fifth step is to drag and drop the just modified .xml file into the compressed worksheet to replace it.

The sixth step is to change the file name suffix to .xlsx, open the Excel form, and the password protection can be cancelled.

The seventh step, after unprotecting the worksheet, you can also re-protect the worksheet and unprotect the worksheet under the [Review] option, as shown in the figure Show.

This article comes from the Excel Tutorial column of the PHP Chinese website.

The above is the detailed content of How to unprotect a worksheet if you forget your protected password in excel. For more information, please follow other related articles on the PHP Chinese website!