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.
- Comparison Table: Which is the Best to Unprotect Excel Sheet Without Password
- Way 1: PassFab for Excel [User Verified]
- Way 2: Online Remover
- Way 3: Google Sheet [Free & Worth a Try]
- Way 4: VBA [Official but Limited]
- Way 5: Zip File
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|
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.
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 recover 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, 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.
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 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.
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.
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.
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 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.
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.
and delete the 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.
The "Unprotect Sheet" dialog box will pop up. Enter the password and hit Ok and the program will unprotect your file.
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.