Excel worksheet is locked and you don’t know the password or forgot password, what can you do? Take it easy. You can remove password from protected Excel sheet with ease.
In Microsoft Excel, you can add multiple passwords to protect a worksheet, among which the “Open” password prevents users from opening an Excel file and the “Modify” password prevents users from modifying cells. However, no matter which password locks an Excel sheet, you can remove the password without knowing it.
If you forgot the Open Password unable to open a protected Excel sheet, you will decide how to remove the password depending on whether the suffix of the protected Excel worksheet is.xls or .xlsx.
Download, install, and then launch Excel Password Remover on your computer. Click on the Open button, navigate to the path to the password protected Excel file with .xls suffix and add it into this software. Then click on the Remove Password button and follow its instructions to remove the password so that you can open the Excel file without password.
As "Excel Password Remover" doesn’t support Excel sheet with .xlsx suffix. Then you have to firstly use Excel Password Refixer to help find the password from the protected Excel sheet. Then open the spreadsheet with the password and then remove password.
If the Excel cells are protected and you can’t modify them, you can remove the password without using any software.
Step 1: Change the Excel file name extension from xlsx to zip.
Step 2: When the Excel file is changed into a ZIP file, double click on the ZIP file to open it. Then open xl -> worksheets. Then you can see three .xml files in the "worksheets" folder.
Step 3: Drag the "sheet1.xml" file into any one folder. Right click on the "sheet1.xml" file and select Open with -> Notepad.
Step 4: The "sheet1.xml" file opens as Notepad. Find the sheetProtection tag and remove it so that you can remove the password from the Excel sheet to unprotect it. After that you can modify the Excel cells without any limits.