It’s very common to protect Excel files by setting open password and restriction password. Meanwhile, removing Excel password becomes necessary as you may find it inconvenient to enter your password every time you want to open or edit Excel. Well, this post is meant for you as it shows you easy steps to remove password from Excel. Keep on reading.
- Part 1: Remove A Password from Excel When You Know It
- Part 2: How to Remove Excel Password When You Forgot It
- Part 3: FAQs about Excel Remove Password
Part 1: Remove A Password from Excel with Known Password
If you have an Excel document with password protection it is annoying to always enter the exact password for that file. So you may want to remove passwords, and there are two possible situations: you want to remove Excel password to open or you can to remove Excel restriction password.
- Case 1: Remove Open Password from Excel File
- Case 2: Remove Excel Restriction Password to Unprotect Worksheet/Workbook
Case 1: Remove Open Password from Excel File
How to remove password from Excel file when opening file? If you know the password, you can try these two methods:
Method 1. Remove Excel Password with Info Feature
You know the password but do not know how to remove password for Excel? Follow the steps and remove the password security easily.
Step 1: First open the Excel file whose password you want to remove. When you open the file you will have to enter the Password.
Step 2: Click on File and then click on Info.
Step 3: Now click on Protect Workbook and in the drop down menu click Encrypt with Password. In older versions you will click on Protect Document > Encrypt with Password.
Step 4: In the dialog box erase the password and click OK.
Step 5: Save the file and your Excel file password protection will be removed.
This method didn't work for you? Don't worry. Move on to the next method.
Method 2. Remove Excel Password with Save As Feature
This method will guide you to remove password for Excel when the password is known. It is an easy way. Follow the steps and your Excel document password protection will be removed.
Step 1: In this method first open your Excel file which is password protected.
Step 2: A dialog box will open asking to enter password. Enter the Password and click OK.
Step 3: Now click on File > Save As and select location where you want to save the Excel file after removing password. If you have an older version of Microsoft Excel, click on Microsoft Office and then on Save As.
Step 4: Before saving the file click on Tools.
Step 5: Now in the drop down menu click on General Options.
Step 6: A dialog box will appear. There you have to clear the existing password in Password to open text box and click OK.
Step 7: Now save the file and you will be able to open the file without entering password.
These two methods apply to removing Excel open passwords. If you want to remove password to modify Excel, check the next case.
Case 2: Remove Excel Restriction Password to Unprotect Worksheet/Workbook
If you have previously set up a password to protect your Excel document from editing, you can unprotect Worksheet or Workbook structure:
Step 1: Open your Excel file, and click the Review tab.
Step 2: Click Unprotect Sheet or Unprotect Workbook Structure.
Step 3: Enter your password in the popup dialog, then click OK.
Now the Excel restriction password should have been removed.
However, how do I remove Excel password if I forgot it? If you find the password you entered is incorrect, or you have forgotten your password, you can try the solutions in Part 2.
Part 2: How to Remove Password from Excel If You Forgot It
How to remove a password from Excel if you forgot it? You can try a top Excel password remover for automatically removing password from Excel file. PassFab for Excel is the tool you can tackle this frustrating situation. It is the quickest and most efficient software to recover or remove the Excel password when you have forgotten or lost it.
Key Features:
- You can recover Excel open passwords.
- It supports removing password from Excel Workbook and Worksheet (aka unprotect worksheet and workbook structure).
- It won't cause data loss.
- It supports all the versions, for example, Excel 2019, 2016, 2013, 2010, 2007, and earlier.
Option 1. How to Remove Excel Password to Open
So this software is all in one package for your problems. It provides 3 different attack options which are Brute-force with Mask Attack, Brute-force Attack, and Dictionary Attack. Each attack option has its own parameters and password recovering time. Following is the method to remove the password when you don’t seem to remember it using this Excel password recovery tool.
Step 1: Launch the Excel password recovery tool, you will see two functions. Choose "Recover Excel Open Password" and continue.
Step 2: Add the Excel document and select any decryption method. You can customize the Settings for the selected method.
Step 3: Click on Recover and the software will initiate the process to decrypt the password for the Excel document. It will take time to wait until the process is completed. The duration of the decryption depends on the method selected.
Step 4: When the process is completed, the password recovered will be displayed in the dialog box.
Finally, in order to open the Excel file without typing password again, you need to follow the methods in Part 1.
Option 2. How to Remove Excel Password to Modify
Removing password protection from Excel would be much easier using PassFab for Excel. You can do it automatically with just a few clicks!
Step 1. Run this software and choose "Remove Excel Restriction Password" feature.
Step 2. Import the Excel file that is able to open but unable to modify any content. Then click "Remove" button.
Step 3. Within seconds, you will get rid of the password easily and see the copied Excel file without any password in your computer. Click Open Folder to open your Excel file and edit it.
Here is a video tutorial about how to remove password from Excel spreadsheet:
Summary
So you have now had the full knowledge on how to remove a password from Excel whether you know the password for the document or you have forgotten or lost it. These methods are easy and simple and you can remove the password without any problem. Also, PassFab for Excel is the best choice for people who have little knowledge of computer. It has user interactive interface and is easy to use.
Also Read: Top 15 Efficient Excel Password Recovery Tools.
Part 3: FAQs about Excel Remove Password
Q1: How to remove password from Excel file when opening file?
- If you know the password, you can navigate to File > Info > Protect Workbook > Encrypt with Password, then clear the password inbox to remove it;
- If you forgot the password, a third-party Excel password remover software like PassFab for Excel will help you out.
Q2: How to remove password from Excel file without knowing password?
- If you want to remove Excel open password, you can try a professional Excel password recovery tool;
- If you want to remove Excel restriction password for editing, you may try to remove it via ZIP software or Notepad, or via an Excel password remover.
Q3: Will removing Excel password result in data loss?
Generally it won’t cause data loss by removing your Excel password. You should read carefully before you try the solution.
- Recover Excel Open Password
- Remove Excel Restriction Password
- Support Microsoft Excel 2019, 2016, 2013, 2010, 2007, 2003, XP, 2000 and 97