How To Remove Excel Password

by
How to Remove Excel Password

Forgetting passwords can be frustrating, especially when it comes to important documents like Excel spreadsheets. But don’t worry, there are ways to remove Excel password and regain access to your valuable data.

Option 1: Use Excel’s Unprotect Sheet Feature

If you know the password but just want to remove it, Excel provides an easy solution. Simply follow these steps:

  1. Open the Excel spreadsheet that you want to unprotect.
  2. Click on the “Review” tab in the ribbon at the top of the screen.
  3. Click on the “Unprotect Sheet” button.
  4. Enter the password when prompted.
  5. Click “OK” to remove the password.

Option 1 FAQs:

  1. What if I don’t know the password?

    If you don’t know the password, you’ll need to try one of the other options below.

  2. Will this remove any other protections on the sheet?

    No, this only removes the password protection. Other protections such as cell locking will remain in place.

Option 2: Use a Password Recovery Tool

If you don’t know the password, you can use a password recovery tool to remove it. There are many tools available online, but be careful when downloading as some may contain malware. Here are some popular options:

  • PassFab for Excel
  • iSumsoft Excel Password Refixer
  • Excel Password Recovery Master

Option 2 FAQs:

  1. Are these tools free?

    No, most password recovery tools require a purchase to use.

  2. How do I use a password recovery tool?

    Each tool will have its own instructions, but generally you’ll need to download and install the software, then follow the prompts to recover or remove the password.

Option 3: Use a Macro

If you’re familiar with Excel macros, you can use a simple macro to remove the password. Here’s how:

  1. Open the Excel spreadsheet that you want to unprotect.
  2. Press “Alt” + “F11” to open the Visual Basic Editor.
  3. Click on “Insert” in the menu bar and select “Module”.
  4. Copy and paste the following code into the module:

    Sub PasswordBreaker() 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

  5. Press “F5” to run the macro.
  6. When the macro finishes running, a message box will appear with the password.
  7. Enter the password to unprotect the sheet.

Option 3 FAQs:

  1. What if the macro doesn’t work?

    This macro may not work on all Excel files, particularly those with complex passwords or protections.

  2. What if I don’t know anything about macros?

    If you’re not familiar with macros, this option may not be for you. Stick to the other options above.

Conclusion

Removing Excel passwords can be done in a few different ways, depending on your situation. Try the options above to regain access to your important data.

Next: