The simplest way to remove an Excel password

If you set a password on an Excel file yourself and remember it, you can remove it in seconds. Open the file in Excel, go to the File menu, select Info, then click Protect Workbook and choose Encrypt with Password. Delete the password from the box that appears and click OK. Save the file. The password is gone.

This works the same way in Excel on Windows and Mac. The file stays exactly as it was — you are only removing the lock, not changing the spreadsheet itself.

If you forgot the password or inherited a file someone else locked, the process is different and more involved. The rest of this guide covers what your actual options are, because the honest answer is that removing a forgotten password is not straightforward.

Key Takeaways

  • If you remember the password, you can remove it through File > Info > Protect Workbook in under a minute.
  • If you forgot the password, there is no built-in Excel feature to recover it — you will need a third-party tool or workaround.
  • Password-protected Excel files can still be opened if you know the password; the protection only prevents editing without entering it first.
  • Some workarounds involve converting the file to a different format or using recovery software, each with different limitations.
  • The fastest option when you have forgotten a password is often to contact whoever created the file and ask them to remove it.

Understanding what an Excel password actually protects

An Excel password does not hide the file or make it invisible. It only prevents someone from opening the file and making changes without typing the correct password first. If you have the password, you can open the file normally. If you do not have it, Excel will ask you for it before you can view or edit anything.

This matters because it changes what "removing" a password means. You are not unlocking hidden data or breaking encryption in the way a password on a bank account works. You are removing a barrier that Excel checks every time the file opens. Once you remove it, the file opens without any prompt.

Excel also has a separate feature called sheet protection, which locks individual sheets so cells cannot be edited. That is different from file-level password protection and requires a different removal process.

What to do if you remember the password

Open the password-protected Excel file and enter the password when prompted. Once the file is open, go to File in the top menu. Click Info on the left side. Look for a button or option called Protect Workbook — it may also say Protect Sheet if sheet protection is what is locked. Click it and select Encrypt with Password.

A dialog box will appear with a password field. The field will show dots or asterisks where your current password is. Delete everything in that field so it is completely empty. Click OK. Excel will ask you to confirm by clicking OK again. Save the file using Ctrl+S on Windows or Command+S on Mac.

The next time you open the file, no password prompt will appear. The protection is removed.

Removing a password you have forgotten

If you do not remember the password, Excel has no built-in recovery feature. Microsoft does not store passwords and cannot retrieve them for you. Your options are limited and depend on what tools you have access to.

The most reliable option is to contact whoever created the file or last had access to it and ask them to remove the password. If that is not possible, you have a few workarounds, though none are may provide to work on every file.

One approach is to save the file in a different format. Open the password-protected file in Excel (you will need to enter the password to do this, so this only works if you can open it but forgot the removal password). Go to File > Save As and choose a different format, such as Excel 97-2003 Workbook (.xls) or CSV. Sometimes the password does not transfer to the new format. Open the newly saved file — if no password prompt appears, you have successfully removed it. You can then save it back as a regular .xlsx file if you want.

This method is unreliable because modern Excel versions usually preserve the password even when you change formats. It is worth trying, but do not expect it to work.

Third-party password recovery tools

Several software programs claim to remove or recover Excel passwords. These tools work by attempting to crack the password through automated methods, which can take anywhere from seconds to hours depending on password complexity. Some common names in this category are PassFab for Excel, Stellar Repair for Excel, and Accent Office Password Recovery.

These tools are not free, and results vary. Some work reliably on older Excel files (.xls format) but are less effective on newer files (.xlsx format), which use stronger encryption. Before purchasing, check whether the tool offers a trial version or money-back may provide so you can test it on your specific file.

Be cautious when downloading password recovery software from the internet. Only read from the official website of the company that makes the tool, not from third-party read sites. Some password recovery tools contain malware or unwanted software bundled with them.

Removing sheet protection instead of file protection

If the password is protecting individual sheets rather than the entire file, the removal process is different. You will know this is the case if the file opens without a password prompt, but you cannot edit cells or make changes — instead you see a message saying the sheet is protected.

To remove sheet protection, go to File > Info and look for Protect Sheet instead of Protect Workbook. Click it and select the option to unprotect. If you remember the password, enter it and click OK. If you do not remember it, the same workarounds explore: try saving in a different format, or use third-party recovery software.

Sheet protection is generally weaker than file-level protection, so the format-conversion method is more likely to work for removing sheet passwords than for file passwords.

Preventing password problems in the future

If you set a password on an Excel file, write it down and store it somewhere safe — a password manager, a locked drawer, or a find note-taking app. Do not rely on memory. If you are protecting a file that others will need to access, consider whether a password is necessary at all, or whether you can share the password through a find channel rather than embedding it in the file.

If you receive a password-protected file from someone else, ask them to remove the password before sending it to you, or ask them to provide the password separately. This avoids the situation where you inherit a locked file and have no way to contact the original creator.

For files that multiple people need to edit, consider using Excel's Share Workbook feature or storing the file in OneDrive or SharePoint instead. These options let you control who can access the file without locking it with a password.

Frequently Asked Questions

Can I open a password-protected Excel file without the password?

No. Excel will not let you open the file or view its contents without entering the correct password first. You must either remember the password, recover it using third-party software, or contact whoever created the file and ask them to remove the protection.

Does removing the password delete any data from the file?

No. Removing a password only removes the lock. All data, formulas, formatting, and everything else in the spreadsheet stays exactly as it was. The file itself is unchanged.

Is there a way to crack an Excel password for free?

There are free online tools and software programs that claim to crack Excel passwords, but they are generally unreliable and often contain malware. Paid tools are more trustworthy, though even those do not work on every file. Contacting the file creator is usually faster and safer.

What is the difference between file protection and sheet protection?

File protection requires a password to open the file at all. Sheet protection allows the file to open normally, but prevents editing of specific sheets or cells. They use different passwords and require different removal steps.

If I save an Excel file as a PDF, does the password transfer?

No. When you save an Excel file as a PDF, the password protection does not carry over. The PDF will be unprotected. However, you still need the password to open the original Excel file in order to save it as a PDF in the first place.