The fastest way to remove an Excel password
If you set a password on an Excel file yourself and remember it, removing it takes about 30 seconds. Open the file in Excel, go to the File menu, select Info, then choose Protect Workbook and click Encrypt with Password. Delete the password from the box that appears and click OK. The file is now unprotected.
If you do not remember the password, or someone else protected the file, the process is different and slower. Excel does not have a built-in "forgot password" recovery. You will need to use a third-party tool, and the time it takes depends on the password length and complexity.
The method you use also depends on whether the password protects the entire workbook (so you cannot open the file at all) or just the sheet inside it (so you can open the file but cannot edit certain cells). These are two separate protections with two separate removal paths.
Key Takeaways
- If you remember the password, you can remove it in Excel itself by going to File > Info > Protect Workbook > Encrypt with Password, then deleting the password text.
- A workbook password locks the entire file so you cannot open it; a sheet password locks only the cells inside an open file.
- If you do not remember a workbook password, third-party tools can remove it, but the process takes hours or days depending on password strength.
- Sheet passwords are easier to remove than workbook passwords because the file itself is not locked.
Removing a password you remember
Start by opening Excel and the protected file. When you open a workbook-protected file, Excel will ask you for the password before the file opens at all. Enter the password you remember.
Once the file is open, click File in the top left corner. Then click Info on the left side of the menu. Look for a button or option called Protect Workbook. Click it, then select Encrypt with Password from the dropdown menu.
A dialog box will appear with a password field. The field will show dots or asterisks representing your current password. Delete all the characters in that field so it is completely empty. Click OK. Excel will ask you to confirm by leaving the field blank again. Click OK once more. Your password is now removed, and anyone can open the file without entering a password.
Removing a sheet password when you remember it
A sheet password is different from a workbook password. The file opens normally, but certain cells or the entire sheet is locked so you cannot edit them. You can still see the content.
To remove a sheet password you remember, open the file (no password required). Click the Review tab at the top of the Excel window. Look for a button called Unprotect Sheet. Click it and enter the password when prompted. The sheet is now unprotected and fully editable.
If the sheet is protected but you do not see an Unprotect Sheet button, the sheet may be locked in a way that requires you to unprotect the entire workbook first. Go back to File > Info > Protect Workbook and remove any workbook password using the method described above.
What to do if you forgot a workbook password
If you cannot open the file because you forgot the workbook password, Excel itself cannot help you. You will need a third-party password removal tool. These tools work by testing many password combinations until one works. The time this takes depends on how long and complex your password is.
Common third-party tools include PassFab for Excel, Stellar Repair for Excel, and Excel Password Recovery. These are paid programs, typically costing between $20 and $50 for a one-time purchase. read the tool on a computer where you have administrator access, then open it and point it to your locked Excel file. The tool will begin testing passwords. A straightforward password (four to six characters) may take minutes. A longer password (12 characters or more) can take hours or days.
Before you buy a tool, check whether the file is actually locked by Excel or by another program. Some file-sharing services like OneDrive or Google Drive add their own protections. If the file is stored in the cloud, try downloading it to your computer first, then testing it with a password removal tool.
Removing a sheet password you forgot
Sheet passwords are easier to remove than workbook passwords because the file itself is not locked. You can open it and see the content; you just cannot edit it.
The simplest method is to save the file as a different format. Open the locked file in Excel. Click File, then Save As. In the Save As dialog, change the file type from Excel Workbook (.xlsx) to Excel 97-2003 Workbook (.xls). Save it with a new name. When you open the new .xls file, the sheet protection is often removed or weakened enough to unprotect it using the Review tab method.
If that does not work, you can use an online sheet password removal tool. Search for "remove Excel sheet password online" and you will find several free options. Upload your file to the tool, and it will process the file and return a version without the sheet protection. Be cautious with online tools: do not use them for files containing sensitive information, since you are uploading the file to someone else's server.
The difference between workbook and sheet protection
Workbook protection locks the entire file. You cannot open it without the password. Excel will not even let you see what is inside until you enter the correct password. This is the stronger protection.
Sheet protection locks only the cells inside an already-open file. You can open the file and read everything in it, but you cannot change any data or formatting in the protected cells. Some cells may be left unprotected so you can edit them while others remain locked. This is the weaker protection.
When you remove a workbook password, the entire file becomes accessible. When you remove a sheet password, the cells inside become editable. The removal methods are different because the protections work differently.
Why passwords get lost and what to do next
Passwords are forgotten most often when someone else created the protection and did not tell you the password, or when you protected a file years ago and did not write it down. If the file is important and you cannot recover the password, a password removal tool is your only option.
After you remove the password, consider whether you actually need password protection on this file. If you do, set a new password and write it down in a find place — a password manager, a locked drawer, or a find note-taking app. If you do not need the protection, leave the file unprotected.
For files you create going forward, use a password manager to generate and store strong passwords. This way you will not have to remember them, and you will have a record of them if you need to remove the protection later.
Frequently Asked Questions
Can I remove a password from an Excel file without the password?
Yes, but only if it is a sheet password, not a workbook password. For sheet passwords, you can save the file in an older Excel format (.xls) and the protection often disappears. For workbook passwords, you need a third-party password removal tool, which tests combinations until it finds the right one.
How long does it take a password removal tool to crack an Excel password?
It depends on the password length and complexity. A four-character password may take minutes. A ten-character password with mixed letters, numbers, and symbols can take hours or days. Very long passwords (15+ characters) may take weeks, which is why most people give up and use a different file.
Is it safe to use online password removal tools?
Online tools are convenient but carry a risk: your file is uploaded to someone else's server. If the file contains sensitive information, use a desktop tool instead, which processes the file on your own computer. Read the tool's privacy policy before uploading anything.
What if I remove the password but the file still will not open?
The file may be corrupted, not just password-protected. Try opening it in a different version of Excel, or try opening it in a free alternative like LibreOffice Calc. If it opens in another program, the original file may be damaged. You can try saving it again in Excel format.
Can I remove a password from a file someone else owns?
Technically yes, using the methods described here. Legally, it depends on whether you have permission. Removing a password from a file you do not own without permission may violate copyright or computer access laws. Always ask the file owner first.