How to Remove Password from Excel

Excel spreadsheets are an essential tool for many professionals and businesses. They contain sensitive data that should be protected from unauthorized access. However, if you forget your password or inherit a password-protected Excel file, it can be challenging to access the data. Fortunately, there are several methods to remove passwords from Excel files. In this article, we’ll discuss how to remove password from Excel and provide step-by-step instructions for each method.

Table of Contents

How to Remove Password from Excel File

Excel is one of the most widely used applications for data management, but what happens when you forget the password to your Excel file? The good news is that removing a password from an Excel file is not as difficult as you might think. In this article, we will show you several methods for removing password protection from an Excel file.

Method 1: How to Remove Password Protection in Excel Manually with Info Feature

The first method involves using the Info feature in Excel to remove password protection. Here are the steps:

Step 1: Open the password-protected Excel file and click on File > Info > Protect Workbook > Encrypt with Password.

Step 2: Delete the password from the Password field and click OK.

Step 3: Save the file by clicking on File > Save As > Browse.

Step 4: Choose a location to save the file, give it a new name, and click Save.

Step 5: A message will appear asking if you want to replace the original file with the new file. Click Yes.

Your Excel file is now password-free and can be opened without a password.

Method 2: How to Remove Password With the Save As Option

This method is very similar to the first method, but instead of using the Info feature, we will use the Save As option. Here are the steps:

Step 1: Open the password-protected Excel file and click on File > Save As.

Step 2: Choose a location to save the file and give it a new name.

Step 3: Click on Tools > General Options.

Step 4: Delete the password from the Password to Open field and click OK.

Step 5: Save the file by clicking Save.

Your Excel file is now password-free and can be opened without a password.

Method 3: How to Remove Password from Excel Without Password

If you forgot the password to your Excel file, don’t worry, there is still a way to remove it. You can use a password recovery tool like Passper for Excel to remove the password. Here are the steps:

Step 1: Download and install Passper for Excel on your computer.

Step 2: Open the program and click on Remove Restrictions.

Step 3: Click on the Add button to import the password-protected Excel file.

Step 4: Click on Remove to remove the password.

Step 5: After a few minutes, the password will be removed from the Excel file.

Your Excel file is now password-free and can be opened without a password.

Method 4: How to Recover and Repair Corrupted Excel Files

If your Excel file is corrupted and you can’t open it, you can use a repair tool like Stellar Repair for Excel to fix the file. Here are the steps:

Step 1: Download and install Stellar Repair for Excel on your computer.

Step 2: Open the program and click on Select File.

Step 3: Choose the corrupted Excel file and click on Scan.

Step 4: After the scan is complete, click on Repair.

Step 5: Save the repaired file by clicking on Save Repaired File.

Your Excel file is now repaired and can be opened without a password.

How to Remove Password Protection in Excel Manually with Info Feature

Excel is one of the most widely used spreadsheet applications that is used to store and manage important data. To secure the data from unauthorized access, users often password-protect their Excel files. However, there may be situations where you need to remove the password from an Excel file. This can be a bit tricky, especially if you don’t know how to do it. In this article, we will explain how to remove password protection in Excel manually with the Info feature.

Open the Password-Protected Excel File

To remove the password protection from an Excel file, you need to first open the file in Excel. If the file is password-protected, you will be prompted to enter the password before you can open it.

Click on the File Tab

Once the file is open, click on the File tab in the upper left corner of the screen. This will take you to the Info screen.

Click on the Protect Workbook Drop-Down

On the Info screen, click on the Protect Workbook drop-down menu. This will display a list of options.

Click on the Encrypt with Password Option

From the list of options, click on the Encrypt with Password option. This will open the Encrypt Document dialog box.

Delete the Password

In the Encrypt Document dialog box, delete the password from the Password field. Once you have deleted the password, click on the OK button.

Save the Changes

Finally, save the changes you made to the file by clicking on the Save button in the upper left corner of the screen. The password protection should now be removed from the file.

It’s important to note that removing password protection from an Excel file can compromise the security of the data in the file. Only remove the password protection if you are sure that it is safe to do so.

By following these steps, you can remove password protection in Excel manually with the Info feature. If you don’t remember the password and cannot open the file, don’t worry. There are other ways to remove password protection from an Excel file, as we will discuss in the next section.

How to Remove Password With the Save As Option

If you have forgotten the password to your Excel file, or if you need to remove the password protection from an Excel file without knowing the password, you can use the Save As option to create a copy of the file without the password protection. This method is a bit different from the previous method and involves creating a copy of the file instead of removing the password directly. Here’s how to remove password protection from an Excel file with the Save As option.

Open the Password-Protected Excel File

Open the Excel file that is password-protected.

Click on the File Tab

Click on the File tab in the upper left corner of the screen. This will take you to the Info screen.

Click on the Save As Option

On the Info screen, click on the Save As option.

Select a New Location and Name for the File

In the Save As dialog box, select a new location and name for the file. Make sure to select a location where you have write access.

Select the Excel Workbook (*.xlsx) Format

From the Save As Type drop-down list, select the Excel Workbook (*.xlsx) format.

Click on the Tools Drop-Down Menu

Click on the Tools drop-down menu in the lower right corner of the dialog box.

Click on General Options

From the Tools drop-down menu, click on General Options. This will open the General Options dialog box.

Delete the Password

In the General Options dialog box, delete the password from the Password to open field. Leave the Password to modify field blank.

Click on OK

Click on the OK button to close the General Options dialog box.

Save the File

Finally, save the file by clicking on the Save button in the lower right corner of the dialog box. The new file should be saved without the password protection.

By following these steps, you can remove password protection from an Excel file without knowing the password. This method involves creating a copy of the file without the password protection. However, keep in mind that anyone with access to the new file will be able to view the contents of the file, so make sure to keep it secure.

How to Remove Password from Excel Without Password

Have you ever forgotten the password for an important Excel file and need to access it urgently? Don’t worry, there are several methods you can use to remove the password from Excel without needing to know the password. In this section, we’ll explore a few different approaches you can take.

Use VBA Code

One way to remove the password from an Excel file is to use Visual Basic for Applications (VBA) code. Here are the steps:

Step 1: Open the Excel file and press Alt + F11 to open the VBA editor.

Step 2: Click on Insert and then select Module.

Step 3: Copy and paste the following code into the 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

Step 4: Press F5 or click on the Run button to run the code.

Step 5: The VBA code will generate a usable password that you can use to unlock the Excel file. Note this password down and use it to open the file.

Use an Online Password Remover

Another way to remove the password from an Excel file is to use an online password remover. There are several websites that offer this service for free. Here are the steps:

Step 1: Visit an online password remover website such as LostMyPass or FreeMyPDF.

Step 2: Upload the Excel file you want to remove the password from.

Step 3: Follow the instructions on the website to remove the password from the Excel file.

Step 4: Download the unlocked Excel file and open it.

Use a Third-Party Tool

There are also third-party tools available that can help you remove the password from an Excel file. Here are the steps:

Step 1: Download and install a third-party tool such as PassFab for Excel or iSeePassword Excel Password Remover.

Step 2: Launch the tool and select the Excel file you want to remove the password from.

How to Recover and Repair Corrupted Excel Files

Excel is a widely used software for data analysis and management. However, sometimes due to various reasons, such as sudden power outages or system crashes, Excel files may become corrupted and inaccessible. This can be frustrating, especially if the file contains important data. Fortunately, there are several ways to recover and repair corrupted Excel files. In this article, we will discuss some of the most effective methods.

Open and Repair

The first thing you can try to repair a corrupted Excel file is to use the built-in “Open and Repair” feature in Excel. Here are the steps:

Open Excel and click on “File” in the top-left corner.
Click on “Open” and select the corrupted file.
Click on the drop-down arrow next to the “Open” button and select “Open and Repair”.
Select “Repair” and wait for Excel to repair the file.

Note: If the “Open and Repair” feature doesn’t work, try using “Extract Data” instead.

Use Third-Party Recovery Software

If the “Open and Repair” feature doesn’t work, you can use third-party recovery software to recover the corrupted Excel file. Here are some of the most popular recovery software:

Stellar Repair for Excel
SysTools Excel Recovery
Kernel for Excel Repair

These software programs are designed specifically for recovering corrupted Excel files and can often recover even severely damaged files. However, keep in mind that some of these software programs may come at a cost.

Recover from Previous Versions

If you have enabled the “AutoRecover” feature in Excel, there may be a previous version of the file that you can recover. Here are the steps:

Open Excel and click on “File” in the top-left corner.
Click on “Info” and select “Manage Workbook”.
Click on “Recover Unsaved Workbooks” and select the file you want to recover.
Save the recovered file to a safe location.

Note: This method may not work if you haven’t enabled the “AutoRecover” feature in Excel.

Use a File Repair Tool

Another way to repair a corrupted Excel file is to use a file repair tool, such as the Microsoft Office Configuration Analyzer Tool (OffCAT). Here are the steps: