Home Office

How to Unprotect Excel Sheet in 4 Ways

By Asmi Dhakal

How to Unprotect Excel Sheet in 4 Ways

You can unprotect an Excel sheet with or without a password.

If you have the password, you can simply unprotect it from the Review tab.

However, if you’ve forgotten or lost the password, you’ll have to apply a few workarounds including removing the protection code, and using Google Sheets, or a third-party app.

Note: Before you begin, make sure it is the sheet and not the workbook you’re trying to unprotect. You cannot unprotect an Excel workbook without a password.

If You Have the Password

Use this method if you’re the owner, or if the owner of the sheet has shared the password with you.

Excel will prompt you to enter the password when you try to access a restricted command. If this becomes a chore every time you open the sheet, you can unprotect your sheet by removing the password.

  1. Open your protected sheet.
  2. Head to Review > Unprotect Sheet.
    Unprotect-sheet-tool-1024x576
  3. Enter your password then hit OK.
    Unprotect-sheet-with-password-Excel-1024x576

If You Don’t Have the Password

Using File Compressor

  1. Open File Explorer and navigate to the location of your file.
  2. Make a copy of your file (Ctrl + C > Ctrl + V)
    Make-a-copy-of-your-file-1024x576
  3. Select the copy and press F2 to rename the file.
  4. Change the .xlsx extension to .zip.
    Change-to-zip-file-1024x576
  5. Click Yes on the warning message.
    file-extension-warning-1024x576
  6. Open the compressed file.
  7. Navigate to xl > worksheets.
  8. Locate the protected sheet and drag and drop it to your desktop.
    Drag-and-drop-to-desktop-1024x576
  9. Right-click on the sheet, go to Open with and choose Notepad.
    Open-xml-file-with-notepad-1024x576
  10. Press Ctrl + F and enter Protection.
  11. Remove the protection command.
    Remove-sheet-protection-command-1024x576
  12. Use Ctrl + S to save the file.
  13. Head back to the worksheets folder.
  14. Delete the protected worksheet and replace it with the one on your desktop.
    Copy-file-back-to-folder-1024x576
  15. If prompted, click Yes on the confirmation box.
  16. Change the .zip extension back to .xlsx.
    change-file-extension-1024x576
  17. Select Yes on the warning message.

Import to Google Sheets

  1. Open a Google Sheets document on your browser.
  2. Go to File > Import.
    Import-option-Google-docs-1024x576
  3. Switch to Upload > Browse.
  4. Navigate and select your protected sheet and click Open.
  5. Click Import Data.
    Import-Excel-file-to-google-docs-1024x576
  6. To export the data back to an Excel file, go to File > Download > Microsoft Excel (.xlsx)

Use a Third-party App

Sure, the methods we discussed above consist of a lot of steps. If you feel comfortable, you can use third-party applications to speed up the process.

Some of the third-party apps include Passper for Excel, Excel Password Recovery Master, and Straxx Excel Password Remover.

Disclaimer: Third-party applications aren’t always reliable. Therefore, make sure you research thoroughly through user reviews.