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 forget or misplace the password which renders the file virtually useless as they can’t edit or change the data. Before you start worrying, let me tell you that there’re many ways to unprotect an Excel sheet.

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.

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.

Pros of PassFab for Excel

  • Quick and easy to install and use.
  • Retrieves the lost password without losing any data.
  • Uses 3 advanced attack types for password recovery.

Price of PassFab for Excel

PassFab for Excel has left the tongues wagging in the market – thanks to its competitive prices. You can get its monthly license for $15.95 and yearly license for $19.95 while its lifetime subscription can be availed at just $39.95.

Check the updated prices and discounts here.

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 recovere 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 and let the program does the job for you.

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 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, this method 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 4: 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 black 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

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.

Comparison Table: Which Is the Best Unprotect Excel Sheet Without Password

Even though all the four methods and tested and tried, but they differ in their efficiency and success rate. Read the below comparison table to find out which method stands out:

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

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

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 remove the password from Excel files with just a few clicks.

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

COMMENT