How to remove a password from an Excel file

Once you have activated password pro­tec­tion in Microsoft Excel, there are several ways to remove the Excel password from the file. Removing Excel sheet pro­tec­tion is easy with the right approach.

How to remove a password from an Excel file quick guide

1. Open the file and enter the password.
2. Go to File > Info > Protect Workbook > Encrypt with Password.
3. Delete the password.
4. Save the file.

Step-by-step in­struc­tions on how to remove password pro­tec­tion from an Excel file

With the following steps, you can remove password pro­tec­tion and en­cryp­tion from an Excel file if you know the password or have it stored in your password manager. Once you have removed the password from the Excel file, it can be opened without a password.

Step 1: Open the password-protected file by entering the password.

Step 2: Then select File > Info > Protect Workbook > Encrypt with Password from the menu.

Step 3: In the dialog window, delete the existing password. After doing this, you won’t receive any more prompts to enter a password when you open the workbook.

Step 4: Once you save the Excel workbook, password pro­tec­tion is removed. The file can now be opened without a password.

Step-by-step in­struc­tions on how to unprotect an Excel sheet

It takes just a few clicks to unprotect a single Excel worksheet and allow anyone to edit it again.

Step 1: In the Review menu, select the Unprotect Sheet option.

Step 2: If the worksheet was protected with a password, you must now enter the password.

Result: If you’ve entered the correct password, the Excel sheet will now be un­pro­tect­ed. Any user can now edit the worksheet as they please.

What to do if you’ve lost the password to your Excel file

Removing an Excel password only works if you know the password. But what should you do if you no longer have the password to an encrypted Excel file? The bad news is that the password pro­tec­tion of an encrypted Excel file cannot be cracked because it is com­pa­ra­ble to that of an encrypted ZIP file.

Your only option is to try to guess or recover the password. The­o­ret­i­cal­ly, you could attempt to crack the password with a brute force attack, i.e., by au­to­mat­i­cal­ly trying all com­bi­na­tions. However, this only works if you orig­i­nal­ly chose a par­tic­u­lar­ly short and trivial password such as “1234”. If, on the other hand, you created a secure password, all attempts of this nature will be futile.

How to unprotect an Excel sheet without a password

Things aren’t quite as hopeless if you want to unprotect a single Excel worksheet but no longer know the password. There is actually a trick for this. However, it involves file ma­nip­u­la­tion, and there’s no guarantee it will work with all current and future versions of Excel. Of course, we assume that you will only attempt this if you are au­tho­rized to do so.

Step 1: Before per­form­ing any of the steps below, make a copy of the Excel file in question. Carry out the following steps using the copied version, because if you make a mistake while modifying the file, you still have the un­mod­i­fied original version and can start over.

Step 2: Open the copy of the file with 7-Zip. The 7-Zip program comes pre­in­stalled on Windows 10, so all you need to do is right-click on the file and select Open from the 7-Zip menu. If 7-Zip is not installed on your system, you can download it online for free.

Step 3: Open the xl folder inside 7-Zip.

Step 4: Now open the work­sheets folder.

Step 5: Now you can view one or more files like sheet1.xml, sheet2.xml, etc. These files cor­re­spond to the in­di­vid­ual work­sheets of your Excel file. Let’s assume your protected worksheet cor­re­sponds to the sheet1.xml file. If you have more than one worksheet, you may need to determine which Excel sheet you need to remove the password pro­tec­tion from.

Now, edit the file using a text editor. The easiest way to do this is to right-click the file in 7-Zip and then click on Edit. Al­ter­na­tive­ly, you can select it and press the [F4] key.

Step 6: The file is now open in the Windows editor. As you can see, XML files are not exactly reader-friendly because they are usually not intended for human eyes. Make sure that text wrap is enabled in the text editor (Format > Wrap Text) so that the text does not scroll out sideways.

Now, look for the string <sheetProtection in the text and select all text up to the closing />:

This XML entry rep­re­sents the sheet pro­tec­tion.

Step 7: Delete the entry you have selected, starting from <sheetProtection all the way up to the next />. Be careful not to delete anything else so as not to damage the structure of the XML file.

Step 8: Close the text editor. To save the changes, you need to confirm them. Since you opened the file in 7-Zip, 7-Zip will now ask: “The file sheet1.xml has been changed. Should it be updated in the archive?” Confirm the changes so that they are applied to the Excel file and close 7-Zip.

Result: You can now open the modified copy of the file in Excel. You will find that the sheet pro­tec­tion has been removed and the worksheet can now be edited again.

While this method lets you remove Excel sheet pro­tec­tion, you cannot find out which password was pre­vi­ous­ly used. As shown in the text editor, the password is stored in­ter­nal­ly using hash values, making it im­pos­si­ble to be worked out.