You can remove a password from an Excel file, but the method depends on whether you set the password yourself
If you created the password and remember it, Excel lets you remove it directly through the program. Open the file, go to the File menu, select Info, then choose Protect Workbook and pick Encrypt with Password. Delete the password from the box and click OK. The file is now unprotected.
If you forgot the password or inherited a protected file from someone else, you have fewer options. Excel does not have a built-in "forgot password" recovery. You would need to use a third-party tool designed to remove Excel passwords, though these tools vary in reliability and cost. Some are free; others charge a one-time fee or subscription. None of them work when ready — most take hours or days to crack a strong password.
Before you try to remove a password, consider whether you actually need to. Password-protected spreadsheets exist for a reason: to keep sensitive data like payroll, medical records, or financial information from being changed or viewed by the wrong person. If someone else set the password, removing it without permission may violate your workplace policy or create a security problem.
Key Takeaways
- If you know the password, you can remove it through File > Info > Protect Workbook > Encrypt with Password, then delete the password and click OK.
- If you forgot your own password, third-party password removal tools exist but may take hours or days and are not always reliable.
- If someone else password-protected the file, ask them for the password rather than trying to remove it — removing it without permission can create security or legal problems.
- Password protection in Excel usually protects the sheet structure or cell contents, not the file itself, so the protection level matters when deciding whether removal is worth the effort.
The difference between sheet protection and workbook protection
Excel has two types of password protection, and they work differently. Sheet protection locks individual cells or ranges so they cannot be edited or deleted, but the sheet itself stays visible and readable. Workbook protection locks the structure of the file — you cannot add, delete, or rename sheets, though you can still see and edit the data inside them.
If a sheet is protected but not the workbook, you can still open the file and read it. You just cannot change anything. If the workbook is protected, the sheet tabs at the bottom are locked. Knowing which type of protection is in place helps you decide whether you need to remove it at all. Many people password-protect sheets to prevent accidental changes, not to hide information. In those cases, you might not need to remove the password — you might just need to ask the file owner to unprotect it temporarily while you work.
How to remove a password you set yourself
Open the Excel file and go to the File menu in the top left. Click Info, then look for a button or link that says Protect Workbook or Protect Sheet, depending on which type of protection is on the file. Click it and select Encrypt with Password (for workbook protection) or Unprotect Sheet (for sheet protection).
If you chose Encrypt with Password, a dialog box will appear with a password field. The field will show dots or asterisks where your password is. Delete everything in that field and leave it blank, then click OK. The protection is now removed. If you chose Unprotect Sheet, you will be asked to enter the password. Type it in and click OK. The sheet is now unprotected.
Save the file after you remove the password. Use Ctrl+S on Windows or Command+S on Mac. The file will save without password protection from that point forward.
What to do if you forgot the password
If you set the password yourself but cannot remember it, Excel does not have an official recovery option. Microsoft does not store your passwords and cannot retrieve them for you. Your choices are limited to third-party tools or starting over with a new file.
Third-party password removal tools work by running through possible password combinations until they find the right one. This process is called brute-force cracking. Tools like PassFab for Excel, iSunshare Excel Password Remover, and others claim to remove Excel passwords, but they work at different speeds depending on password length and complexity. A straightforward four-character password might take minutes. A 12-character password with numbers, uppercase, and lowercase letters might take days or weeks, even on a fast computer.
Before you buy or read a tool, read recent reviews from people who actually used it. Some tools are scams or contain malware. Stick to tools from established software companies with public websites and customer support. Many offer a free trial that lets you see if your password can be cracked before you pay.
When to ask for help instead of removing the password yourself
If someone else password-protected the file, your first step should be to ask them for the password or to unprotect it for you. This is faster, safer, and avoids potential problems. If the file belongs to your employer or a client, removing the password without permission could violate a data security policy or even a contract.
If the person who set the password is no longer available — they left the company, you cannot reach them, or they passed away — talk to your manager or IT department. They may have a process for handling this situation. Some organizations keep a record of passwords for critical files, or they may have legal authority to override the protection. Trying to crack the password on your own could be seen as circumventing security controls, which some workplaces treat seriously.
Why password protection matters, even when it is inconvenient
Password-protected spreadsheets are common in workplaces because they prevent two kinds of mistakes. The first is accidental changes: someone opens a file, clicks the wrong cell, and deletes a formula or number without realizing it. The second is unauthorized changes: someone with access to the file modifies data they should not touch, either by accident or on purpose.
If you work with spreadsheets that contain payroll, medical information, financial records, or any data that affects other people, password protection is a reasonable safeguard. Before you remove a password, ask yourself whether the protection is there to keep you from doing something you should not do. If the answer is yes, the password is working as intended.
Alternatives to removing the password
If you need to work with a password-protected file but cannot remove the password, you have other options. You can ask the file owner to save a copy of the file without protection, or to unprotect it temporarily while you make your changes. You can also copy the data from the protected file into a new, unprotected file — this works if you only need to read the data, not edit it in place.
If the file is locked at the workbook level (you cannot add or delete sheets), but you can still edit the cells, you may not need to remove the protection at all. You can work normally; you just cannot restructure the file. If the file is locked at the sheet level, you can still read it and copy data out of it, even if you cannot edit it directly.
Frequently Asked Questions
Can I remove an Excel password without the original password?
Not through Excel itself. You would need a third-party password removal tool, which uses brute-force cracking to guess the password. This can take hours to weeks depending on password complexity. For files you do not own, ask the owner first.
Will removing a password affect the data in the spreadsheet?
No. Removing password protection does not change any of the numbers, formulas, or formatting in the file. It only removes the lock that prevents editing. The data stays exactly as it was.
Is it legal to remove a password from a file I do not own?
That depends on your situation. If it is your employer's file and you have a legitimate work reason to access it, ask your manager or IT department. If it is someone else's personal file, removing the password without permission could be illegal depending on your location and the circumstances.
What if the password removal tool does not work?
Some tools are more reliable than others, and some passwords are too complex to crack in a reasonable time. If a tool does not work after a few hours, try a different tool or ask the file owner for the password. You can also contact the tool's customer support to ask whether your specific password is crackable.
Can I prevent someone from removing a password I set?
Not completely. Any password can eventually be cracked with enough time and computing power. If you need to protect sensitive data, password protection is one layer, but it should not be your only layer. Store the file in a location with restricted access, use file-level encryption, or both.