How to Remove Password Protection From an Excel File

Removing a password from an Excel file depends on which version you're using and what kind of protection is in place

Excel files can be protected in two main ways: with a password to open the file itself, or with a password that locks the sheet structure so you cannot edit cells, add rows, or change formulas. The steps to remove each type are different. If you know the password, you can remove the protection directly. If you do not know the password, your options are much more limited and depend on the Excel version and file format.

This guide covers the most common scenarios: removing sheet protection when you know the password, opening a file when you have forgotten the password, and what to do when neither option works.

Key Takeaways

Sheet protection (which locks cells and formulas) can be removed in seconds if you know the password, using the Tools menu in Excel.
File-level passwords (which prevent opening the file at all) require you to know the password to remove them in modern Excel versions.
Older Excel files (.xls format) can sometimes be opened without the password using third-party tools, but newer files (.xlsx) are much harder to crack.
If you own the file but forgot the password, contacting the person who protected it is usually faster than any technical workaround.
Making a copy of the file and pasting values only can sometimes bypass protection, though this only works for sheet-level locks, not file-level passwords.

Removing sheet protection when you know the password

Sheet protection prevents you from editing cells, but the file itself opens normally. To remove it in Excel on Windows or Mac, open the file and go to the Tools menu (or Review tab in newer versions), then select Protect Sheet or Unprotect Sheet. Excel will ask for the password. Type it in and click OK. The protection is now removed and you can edit freely.

In Google Sheets, the process is similar but the menu location differs. Open the file, click Tools, then Protect sheets and ranges. Find the protected range or sheet in the list that appears on the right side, click the trash icon next to it, and confirm. Google Sheets does not use passwords for sheet protection in the same way — it uses sharing permissions instead — so if a sheet is protected, you may need edit access from the file owner rather than a password.

Opening a file when you have forgotten the password

If the file itself is password-protected and you cannot open it, the steps depend on the file format. Excel files come in two main types: the older .xls format (Excel 97–2003) and the newer .xlsx format (Excel 2007 and later). The newer format is encrypted much more securely, so there is no practical way to open it without the password.

For older .xls files, some third-party tools claim to recover or bypass passwords, though success is not may provide and depends on how the file was protected. These tools work by attempting to crack the password or by exploiting older encryption methods. Search for "Excel password recovery" to find options, but be cautious: download only from reputable sources and scan any tool with antivirus software before running it.

For .xlsx files, there is no reliable workaround. Microsoft's encryption in newer versions is strong enough that brute-force password cracking is not practical for most users. Your best option is to contact whoever protected the file and ask them to remove the password or send you an unprotected copy.

Using the copy-and-paste method to bypass sheet locks

If a sheet is locked but you do not know the password, you can sometimes work around it by copying the data to a new file. Open the protected file, select all the cells with data (press Ctrl+A on Windows or Cmd+A on Mac), and copy them. Open a new blank Excel file and use Paste Special (right-click and select it, or press Ctrl+Shift+V on Windows). Choose Values Only and click OK. This pastes only the numbers and text, not the formulas or formatting, into an unprotected sheet.

This method works only for sheet-level protection, not for file-level passwords that prevent you from opening the file at all. It also means you lose any formulas the original file contained, so the new file will not update automatically if the source data changes. Use this only when you own the data and simply need to work with it in an editable form.

Removing protection from a file you created

If you protected the file yourself but forgot the password, your options are limited. Write down what you remember about the password — the first letter, how many characters it was, whether it included numbers — and try variations. Excel does not have a "forgot password" recovery option like email services do.

If you cannot remember it at all, the copy-and-paste method above will let you recover the data if the protection is sheet-level only. For file-level protection on a newer .xlsx file, there is no practical recovery method. For older .xls files, password recovery tools may work, though there is no may provide.

Going forward, store passwords in a password manager like Bitwarden, 1Password, or the password manager built into your browser. This prevents you from losing access to your own files.

Understanding the difference between file and sheet protection

These two types of protection look similar but work very differently. File-level protection means the entire file is encrypted and you cannot open it without the correct password. When you try to open the file, Excel asks for the password before showing you any content. Sheet-level protection means the file opens normally, but certain cells or the entire sheet are locked so you cannot edit them.

To tell which type you are dealing with, try opening the file. If Excel asks for a password before the file opens, it is file-level protection. If the file opens but you cannot edit cells or you see a message saying "the sheet is protected", it is sheet-level protection. Sheet-level protection is much easier to remove if you know the password, and sometimes possible to work around even if you do not.

What to do if you need the file but cannot unprotect it

If you own the file or have legitimate access to it, contact the person who protected it. They can remove the protection and send you an unprotected copy, which is usually faster than any technical workaround. If the file came from your workplace, ask your IT department or the file's creator. If it came from a client or vendor, email them and explain that you need to edit the file.

If the file is very old and the person who protected it is no longer available, you may have to accept that the data is locked. In that case, the copy-and-paste method can at least let you extract the values and work with them in a new file, even if you lose formulas and formatting.

Frequently Asked Questions

Can I remove protection from an Excel file without knowing the password?

For sheet-level protection, you can sometimes copy the data to a new file using paste-special values-only, which bypasses the lock. For file-level passwords on newer .xlsx files, there is no practical method. Older .xls files may be cracked using third-party password recovery tools, though success is not may provide.

What is the difference between .xls and .xlsx files?

.xls is the older Excel format (1997–2003) and uses weaker encryption. .xlsx is the newer format (2007 and later) and uses much stronger encryption that is not practical to crack without the password. If you have a choice, always use .xlsx for files you want to protect securely.

If I unprotect a sheet, will it affect the formulas or data?

No. Unprotecting a sheet only removes the lock that prevents editing. All formulas, data, and formatting stay exactly as they were. You are simply regaining the ability to change cells.

Can I remove protection from an Excel file on my phone or tablet?

Excel on mobile devices (iPhone, iPad, Android) has limited protection-removal features. If the file is sheet-protected and you know the password, you may be able to unprotect it through the Tools or Review menu, depending on your device and Excel version. For file-level passwords, mobile Excel cannot remove them. Use a desktop or laptop computer for password removal.

What if the file is protected but I do not know who protected it?

If you own the file, try the copy-and-paste method to extract the data into a new unprotected file. If you do not own it and cannot contact the creator, you are limited to reading the file but not editing it. For very old files, password recovery tools for .xls format may work, but there is no may provide.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.