iSumsoft » Resources » Office » How to Remove Password from Protected Excel Sheet

How to Remove Password from Protected Excel Sheet

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.


Part 1: How to remove Open password from protected Excel sheet

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.

1. Remove Open password from protected .xls sheet using Excel Password Remover

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.

Excel Password Remover

2. Remove Open password from protected .xlsx sheet using Excel Password Refixer

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.

Excel Password Refixer

Part 2: How to remove Modify password from protected Excel sheet

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.

Change Excel extension

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.

Open sheet1 file as 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.

Remove password from Excel sheet