Removing password protection depends on whether you locked the sheet, the workbook, or the file itself

Excel has three different protection levels, and each one removes differently. A sheet password locks individual worksheets so you cannot edit cells, insert rows, or change formulas — but you can still open the file. A workbook password prevents someone from adding, deleting, or rearranging sheets. A file password encrypts the entire document so it cannot open without the correct password. If you know the password, all three are straightforward to remove. If you do not know it, your options are limited.

The steps differ between Excel on Windows, Excel on Mac, and Excel online. This guide covers the desktop versions where you have the most control. Online versions have fewer options for managing protection.

Key Takeaways

  • Sheet protection and workbook protection can be removed instantly if you know the password — just go to the Review tab and click Unprotect.
  • File passwords (encryption) require you to enter the correct password when opening the file; there is no way around this if you do not know it.
  • If you forgot the password, third-party tools exist but are slow and unreliable for complex passwords, and some require payment.
  • On Mac, the process is the same as Windows but the menu locations are slightly different — look for Review instead of Tools.
  • Removing protection from a file you own is legal; removing it from someone else's file without permission is not.

Removing sheet protection when you know the password

Sheet protection is the most common type. It prevents changes to cells, formulas, or structure while still letting you view and read the spreadsheet. If you know the password, removing it takes seconds.

Open the file in Excel. Click the Review tab at the top. Look for the Unprotect Sheet button (it may say "Protect Sheet" if the sheet is not currently protected). Click it. If the sheet is protected, Excel will ask for the password. Type it in and click OK. The sheet is now unprotected and you can edit it freely.

If you do not see the Review tab, you may be using an older version of Excel. In Excel 2003 and earlier, go to Tools menu, then Protection, then Unprotect Sheet.

Removing workbook protection when you know the password

Workbook protection prevents you from adding, deleting, hiding, or unhiding entire sheets. The file itself opens normally, but you cannot change its structure. Removing it follows the same path as sheet protection.

Open the file. Click the Review tab. Click Unprotect Workbook. If a password is set, enter it and click OK. The workbook is now unprotected.

Some workbooks are protected without a password — this is rare but possible. In that case, clicking Unprotect Workbook will remove the protection immediately with no prompt.

Removing file encryption (password-protected files)

File encryption is different from sheet or workbook protection. When a file is encrypted, Excel will not open it at all without the correct password. You see a password dialog before the spreadsheet loads.

If you know the password, simply enter it when prompted and the file opens normally. To remove the encryption so the file opens without a password in the future, open the file, then go to File > Info > Protect Workbook > Encrypt with Password. Delete the password from the box and click OK. Save the file. The encryption is now removed.

On Mac, the path is File > Properties (or Preferences depending on your Excel version) and look for Security or Encryption options.

What to do if you do not know the password

If the file is encrypted with a password you do not know, Excel will not open it. There is no built-in way to bypass this. Microsoft does not provide a password recovery tool for Excel files.

Third-party password recovery tools exist, but they work by trying many passwords in sequence — a process called brute force. For simple passwords (under 6 characters, numbers only), this may take minutes. For longer or more complex passwords, it can take hours, days, or longer depending on the tool and your computer. Some tools charge per file or per recovery attempt. Results are not may provide, especially for passwords longer than 8 characters.

If you own the file and set the password yourself, your best option is to try common passwords you may have used. If that fails, contact whoever gave you the file and ask them to send an unprotected version or provide the password.

Removing protection on Mac

The process on Mac is nearly identical to Windows. Open the file in Excel. Click the Review tab (or Tools in older versions). For sheet protection, click Unprotect Sheet. For workbook protection, click Unprotect Workbook. Enter the password if prompted.

For file encryption, go to File > Properties and look for a Security section. Some Mac versions label this differently — if you cannot find it, try File > Preferences > Security. The steps to remove the password are the same: delete the password and save.

Removing protection in Excel Online

Excel Online (the browser version) has limited protection features compared to the desktop app. You can view and edit protected sheets, but you cannot remove the protection from within the browser. To remove protection, you must download the file to your computer, open it in desktop Excel, remove the protection, and upload it back.

Click Download or Download a Copy from the File menu. Open the downloaded file in Excel on your computer. Follow the steps above to remove the protection. Save the file. Upload it back to OneDrive or SharePoint if needed.

Frequently Asked Questions

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

Not reliably. If the file is encrypted (password-protected at open), you need the correct password. If only the sheet or workbook is protected, third-party tools can attempt to crack the password, but this is slow and may not work for complex passwords. For files you own, contacting the person who sent it to you is faster.

Is it legal to remove password protection from a file?

It is legal to remove protection from files you own or have permission to modify. Removing protection from someone else's file without their permission is not legal. If you received a protected file from your employer or a client, ask them for the password or an unprotected version.

What is the difference between sheet protection and file encryption?

Sheet protection prevents editing within the spreadsheet but the file still opens normally. File encryption prevents the file from opening at all without the password. Sheet protection is easier to remove if you know the password. File encryption is stronger but also means you cannot access the file without the correct password.

Will removing protection affect the data in the file?

No. Removing protection only changes whether the file or sheet is locked for editing. The data itself is not altered, deleted, or changed in any way. Once protection is removed, you can edit the file normally.

Can I remove protection from multiple Excel files at once?

Not automatically. You must open each file individually and remove the protection. If you have many files to unprotect and you know the password, you could write a macro to automate the process, but this requires some knowledge of Excel VBA programming.