Home » Spreadsheet Software » How To Unlock Excel Spreadsheet

How To Unlock Excel Spreadsheet

How To Unlock Excel Spreadsheet

A. Unblock a spreadsheet in Excel
1. Open the worksheet that is protected.
2. Click the “Review” tab.
3. Click “Unprotect Sheet”. The calculation time will now be unlocked.
If the worksheet is password protected, type the password to unlock the worksheet.

B. Unlock a password protected document using Google Docs
1. Opens the Excel spreadsheet that is protected.
2. Go to the Google Docs page using your web browser: https://docs.google.com/.
3. Sign in to your Google account or select the option to create a new Google account. You need to have a Google account to access Google Docs and use its features.
4. Once you’re signed in to Google Docs, click “New” and select “Sheets.”
5. Returns to the Excel spreadsheet that is protected.
6. Click the cell in the corner that has no label, which is located above row 1 and to the left of column A. All the data in your spreadsheet will be selected.
7. Select “Copy” to copy all data or press ^ Ctrl + C on your keyboard.
If you are using a Mac, press ⌘ Command + C to copy all data.
8. Go back to the Google spreadsheet and paste the data you copied from the protected Excel sheet. Now the data will be unprotected and you can work with them on Google.

C. Unlock a password protected document using developer code
1. Opens the Excel spreadsheet that is protected.
2. Press ⎇ Alt + F11. This way, you can work with your spreadsheet in developer mode.
3. Copy and paste the following code into the blank space of developer mode:
“Sub Password Breaker ()
‘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 “A possible 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”

4. Click “Run” at the top of the window, or press F5 to run the command. Excel will display a message on the screen that will contain the password of your spreadsheet.
5. Enter the password and click OK.
6. Click the “Review” tab, then click “Unprotect Sheet”.
7. Enter the password for the document. Now your Excel worksheet will be unlocked.

Other Collections of How To Unlock Excel Spreadsheet

how to unlock password protected excel file 2013how to unprotect excel sheet without password freehow to unlock protected excel sheet onlinehow to unlock an excel spreadsheet without the password 2013how to unlock excel spreadsheet with passwordow to unlock excel spreadsheet for editinghow to unprotect excel sheet without password onlinehow to unprotect excel sheet 2010 if forgot password