How to unprotect excel sheet without password 2021

unprotect excel sheet without password

If you come here, you must forget your excel worksheet protected password for editing. But do not worry and this is not the end of the world.

First, you must be sure it is the sheet password for editing. About the workbook password, see: How do i remove protection from an excel workbook Without password?

1. Change the excel file’s extension to .zip.
2. Use Winrar to open this zip file, open the folder named xl, and then the folder called worksheets.
3. Open the sheet with a protected password, Find the word “protect” and press Enter.
4. Delete the tag which is similar to the one below.

<sheetProtection algorithmName=”SHA-512" hashValue=”hAo+ZjcT4csA/8GCvSUhac+H+68FaEQW9itsXOuG1LIMqD2Ij9VyGD0/tf5pDuKntCQNJTU5D00twKbjk6RpXw==” saltValue=”A0a6uGHmPOP6pLoSJ54Uxw==” spinCount=”100000" sheet=”1" objects=”1" scenarios=”1"/>

5. Close it and change the file extension to .xlsx.

6. Now it’s editable.

If you want an introduction with illustrations, read:

How can I unprotect an Excel Sheet without the password? — Windows