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.
- Way 1: Unprotect an Excel Sheet - PassFab for Excel [User Verified]
- Way 2: Unprotect Excel Worksheets - Online Remover
- Way 3: Unprotect a Sheet in Excel - VBA [Official but Limited]
- Way 4: Unprotect Excel Worksheet - Google Sheet [Free & Worth a Try]
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.
Watch this video guide to learn how to use this amazing tool to regain access to your password locked Excel sheet.
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.
Now, click on the “+” icon to browse the load the Excel file into the program and hit on Remove.
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.
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.
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.
Now, hit on the Remove Password option and wait until the service removes its password.
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.
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.
'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)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
On the pop-up window, paste the code shown in the figure.
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.
From your web browser, navigate to https://www.google.com/sheets/about/
Sign in to Google Docs if you already have an account or create a new one and then, log in.
After that, hit Sheets present in the left tab.
Now, click on Blank to create a new sheet.
Open the protected Excel file and press Ctrl + A to select all the cells in the document.
Now, hit Ctrl + C to copy the selected 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.
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.
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|
This table makes it clear that PassFab for Excel is your best bet to unprotect an Excel sheet.
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.