
Each sheet will be named as, "sheet1.xml".Ĭhoose "Edit" by right clicking on the locked worksheet, it will open the file in notepad. Now open the "xl" folder and also "worksheets" folder which will give you all the sheets of the document file. You will open it with your zip extractor.

Right click on the zip file and choose "Open archive". Now you will have to extract the zip file by using any zip extractor like "7zip" or "WinRAR". You will be able to see the file extension after the file name of your Excel file. Follow these steps to learn how to decrypt Excel password by using a zip software.įirst you will change the file extension of the Excel file from ".xlsx" to ".zip". In this method, you will have to use a zip software to decrypt the Excel file. If your file is password protected, then you can unlock it by following Solution 1. If you can't edit a worksheet and the structure of a workbook/worksheet is locked, then you can use this method. Solution 2 – Use Zip Software to Unencrypt Excel sheet Remove the password from the "Password to open" box and click on "OK".

Now you will see a new window and you will have to go to the "Security" option from the 13 options presented before you. Go to "Tools" option from the menu bar and then select "Options…". Open the encrypted Microsoft Excel workbook and type the right password. You will see a dropdown menu like below and now click on "Encrypt with Password".

Go to "File" from the top left corner of the menu, click on "Info" and then click on "Protect Workbook" option from the "Permissions" option. Open the encrypted Microsoft Excel workbook and type the correct password. Just follow the below steps to learn how to decrypt Excel file. For different versions of Microsoft Excel the options may be slightly different, but the main thing is still the same. If you know the password of the Excell 2010 to 2019 file, then you won't have to do much. Part 2: How to Unencrypt Excel File with Password
