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.