Hi team need support to unprotect my sheet which is password protected and forgot the password.

If you’re also facing the same issue, you’re not alone. A lot of users forgot password for protected excel sheet so that they can’t edit or change the data. If you forgot the password you use to protect an excel worksheet, how do you unprotect it?

To help our readers, we have scoured the internet and curated a list of the best methods you can rely on to learn how to unprotect a sheet in Excel.

How to Unprotect Sheet in Excel without Password

For all the users wondering how do I unprotect a sheet in Excel, below are the four easy ways to do that. Implement them one by one and rest assured, one of them will definitely work for you.

Comparison Table: Which is the Best to Unprotect Excel Sheet Without Password

All the five methods are tested and tried, but they differ in their efficiency and success rate. Read the below comparison table to find out which method is the right fit for you to unprotect an Excel sheet:

Method Ease of Use Success Rate Unprotect All Boxes or Not
PassFab for Excel 100% Yes
Online Remover 80% No
Google Sheet 50% No
VBA 50% No
Zip File 50% No

This table makes it clear that PassFab for Excel is your best bet to unprotect an Excel sheet.

Way 1: Unprotect an Excel Sheet - PassFab for Excel [User Verified]

When it comes to unprotecting the Excel sheets, no method or tool is as efficient and comprehensive as PassFab for Excel. Designed specifically for helping users remove Excel password instantly, this amazing tool guarantees that no data will be lost after the process.

Thanks to its intuitive and user-friendly interface, even the newbies can use it without any technical complications.

Features of PassFab for Excel

  • Recover password in .xls, .xlsx, .xlsm, .xlsb format on Excel 2019, 2016, 2013, 2010, 2007, 2003, XP, 2000 and 97.
  • Remove password from excel instantly without damaging original data.
  • 3 password attack types using the latest decryption algorithm.
  • 100% safe to download, install and use in any PC that is running Windows system.

Video Guide

Watch this video guide to learn how to use this amazing tool to regain access to your password locked Excel sheet.

Text Guide

Here’s how to unprotect an Excel worksheet using PassFab for Excel:

  • Launch PassFab for Excel and hit on the "Remove Excel Restriction Password" mode.

    Excel unprotect sheets – remove excel restriction
  • Now, click on the “+” icon to browse the load the Excel file into the program and hit on Remove.

    how to unprotect sheet in Excel – browse excel file
  • It will take hardly a few minutes to completely recover the password. Once done, hit on Open Folder to view your Excel file without no restrictions.

    how to unprotect Excel worksheet – remove password

That’s how simple and easy it is to use PassFab for Excel unprotect an Excel file.

Way 2: Unprotect Excel Worksheets - Online Remover

If you don’t want to install any third-party tool, then this method is your ideal choice. It entails uploading your protected document on its official site, let the program does the job and you can unprotect excel sheet online.

Remember, this website charges you $20 to remove the password and $40 to recover the password.

Text Guide

  • From your web browser, navigate to Online Password Remover.

  • On its Home page, hit on Unprotect Your File and browse the Excel file you want to unprotect.

    unprotect an Excel sheet - online remover
  • Now, hit on the Remove Password option and wait until the service removes its password.

    how to unprotect sheet in Excel - remove password online
  • Finally, download the file on your computer.

Way 3: Unprotect Excel Worksheet - Google Sheet [Free & Worth a Try]

Google Sheet is one of the simplest methods for unprotecting Excel worksheets. Google Sheet works almost similar to Excel in terms of calculations and formulas, the only major difference is Google Sheets provide external links.

This method entails copying the protected excel file into a blank Google Sheet and saving it, allowing you to edit the new sheet.

Text Guide

  • From your web browser, navigate to https://www.google.com/sheets/about/

    unprotect Excel sheet without password – open docs google
  • Sign in to Google Docs if you already have an account or create a new one and then, log in.

    how to unprotect sheet – log in
  • After that, hit Sheets present in the left tab.

    unprotect Excel worksheet – select sheet
  • Now, click on Blank to create a new sheet.

    how to unprotect an Excel worksheet – create new sheet
  • Open the protected Excel file and press Ctrl + A to select all the cells in the document.

    how do i unprotect a sheet in Excel
  • Now, hit Ctrl + C to copy the selected cells.

    unprotecting Excel worksheets – copy cells
  • Now, go to the Google Sheet and hit Ctrl +A to select all cells and then, press Ctrl + V to paste. Save this worksheet and you’ll be able to edit it without password.

    unprotect a sheet in Excel – save file

Way 4: Unprotect a Sheet in Excel - VBA [Official but Limited]

VBA is a tool used to create and organize worksheets and automate many other tasks using OLE automation. You can also use this tool to unprotect an Excel sheet. However, VBA unprotect sheet is viable only if you’re using Excel 2010 or earlier.

Text Guide

  • Launch the protected excel sheet and hit Alt + F11 to open Visual Basic Editor.

  • Now, right-click the workbook’s name, which is Project-VBA pane. Then, click Insert > Module.

    Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
    Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
    MsgBox "One usable password is " & Chr(i) & Chr(j) & _
    Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
    End Sub
    how to unprotect Excel worksheet - insert module
  • On the pop-up window, paste the code shown in the figure.

    Excel unprotect sheets - vba code
  • Hit F5 and wait until the program processes and retrieves the password. The password it generates can be used to unprotect your excel worksheet.

Way 5: Unprotect Excel Spreadsheet - Zip File

Using zip file to unprotect Excel spreadsheet is another method. You can unprotect the sheet offline without any software. This method only works for Excel 2010 and earlier versions. It is not recommended if you’re not that familiar with Excel.

Text Guide

  • Right-click the Excel file and replace ".xlsx" with ".zip". And the Excel file is a Zip file.

  • Extract the Zip file and navigate "xl→worksheets", and open "sheet 1.xml" with Notepad or Wordpad.

    unprotect a sheet in Excel – find sheet1
  • Find and delete the tag.

    unprotect a sheet in Excel – delete tag
  • Save the XML file and re-zip all the extracted file. Change the extension back to ".xlsx" and it's unprotected now.

How to Unprotect a Sheet in Excel with Password

Now, if you have received a protected Excel file and want to unprotect it, then all you need is its password. If you have the password, then follow the below steps to do that:

  • Launch the protected Excel sheet.

  • Navigate to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.

    how to unprotect Excel worksheet - review tab
  • The "Unprotect Sheet" dialog box will pop up. Enter the password and hit Ok and the program will unprotect your file.

Conclusion

To wrap it up, this article has discussed in detail how to unprotect an Excel worksheet without losing any data. All the aforementioned methods have proven to be efficient and trustworthy in helping users unprotect an excel sheet without password with just a few clicks.

Depending on your needs and individual preferences, you can fall back on any method. But as our recommendation goes, you should install PassFab for Excel to recover or retrieve the lost password quickly and safely.

COMMENT