How to Remove Password from Excel File (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

There are many reasons you can use a password to protect a file or a spreadsheet limiting accessibility or editability of the file. And in many cases, you may also need to remove them. Maybe you need to edit the worksheet further. Or simply because you don’t need the restriction anymore. Either way, In this article, you will learn how to remove a password from an Excel file that is encrypted with a password or contains a password-protected worksheet.


How to Remove Password from Excel File: 3 Easy Ways

If your whole file is password protected and you need to insert a password every time you open the file, these methods will help you to remove the password from the Excel file. For example, the first file from the download section. To remove the password from the file, follow one of these methods.


1. Remove Password from Excel File Using Info Option

This method will focus on removing passwords from the Excel files encrypted with passwords. To do that, first, we will be using the Info panel. Follow these steps to see how.

Steps:

  • First, open the file.
  • Then insert the password (“exceldemy” for the file in the download section) and click on OK. The spreadsheets will open up.

  • Now, click on the File tab from your ribbon.

  • After that, click on Info from the panel on the left-hand side.

how to remove password from excel file

  • Next, select Protect Workbook from the right.
  • Then click on Encrypt with Password from the drop-down menu.

how to remove password from excel file

  • Now remove the password from the Password field.

how to remove password from excel file

  • Finally, click on OK.

Now you can reopen the file without any password. As long as the password field is empty you can access it without any password from this point on. This is one way to remove the password from an Excel file.


2. Using Save As Option to Remove Password from Excel File

In addition to the previous method, there is another one you can use to remove a password from an Excel file encrypted with one. In this method, we will be using the Save As option to save the file by removing the password.

Steps:

  • First, open the file.
  • Then insert the password and click on OK. (The password is “exceldemy” for the file from the download section)

how to remove password from excel file

  • Now, click on the File tab from the ribbon.

  • Then, click on the Save As option from the panel on the left-hand side.

  • Now in the Save As box, navigate the file to where you want to save it. Then click on Tools from the bottom as shown in the figure below.
  • After that, click on General Options from the drop-down menu.

how to remove password from excel file

  • As a result, the General Options box will appear. Here, remove texts(passwords) from Password to open and Password to modify fields.

how to remove password from excel file

  • After that click on OK and then Save.

Henceforth, you can open the saved file without any passwords.


3. Zipping Excel File to Remove Password from Protected Worksheet

If you have forgotten the password used to protect an Excel worksheet or workbook, you can unprotect it using this method. Here you only need to have software that can extract .zip files (eg: WinRAR). Remember to back up the file in case it gets corrupted.

Note: This method can only remove passwords from workbook level and worksheet level protection but not from File level protection. To know more about different types of Protection and security in Excel, read this.

Steps:

  • First, go to the View tab in your file explorer and make sure the File name extensions option is checked.

  • Now change the file extension to .zip from .xlsx format.

how to remove password from excel file

  • At this instant, windows will show you a warning box for changing the file extension. Click on Yes.

  • Now, open the .zip file. Then enter the file named xl.

how to remove password from excel file

  • Now, if the protection is on the workbook level, open the workbook.xml file in NotePad. Alternatively, if the protection is on the worksheet level, double-click on the worksheets file.

how to remove password from excel file

  • After that, select the password-protected worksheet. Our workbook here has only one spreadsheet. I am selecting the one as shown in the figure.

how to remove password from excel file

  • Now, click and drag the file to copy it to the file explorer. Then open the copied file as a Notepad.

how to remove password from excel file

  • After that open up the search tool in Notepad by pressing Ctrl+F’ on your keyboard.
  • Now in the Find what field type protection and click on Find Next.

how to remove password from excel file

  • As a result, Notepad will find the line where the word is written.

how to remove password from excel file

  • Now select the entire line starting with the less than sign (<) and ending with the greater than sign (>). Include the signs in the selection.

It should start from here.

how to remove password from excel file

And end here.

remove password from excel file

  • Now press on Backspace or Delete on your keyboard to remove the selection.
  • After that save and close the notepad.
  • Copy the edited Notepad file into the .zip file where we took it from. (xl>worksheets>). Click on OK if an Archive name and parameter box appear.

  • Now close the .zip file.
  • After all of it is done, change the file extension back to .xlsx.

how to remove password from excel file

  • At this instant, the warning box will appear again. Click Yes on it.

As a result, these steps will remove the password from the desired Excel file. Now, open the file and you will find yourself able to edit the spreadsheet again if you have all the steps done right.


Remove Password from Protected Worksheet in Excel

For some files like the second one in the download section, you don’t need any password to access the file. But these are password-protected from editing a spreadsheet further or creating or editing sheets in a workbook. To remove a password from protected spreadsheets in an Excel file, follow one of these methods. One can be used only if you know the password. And other can be used even if you forgot your password.

To use this method, you need to remember the password. To remove a password from an Excel file in a protected spreadsheet, follow these steps.

Steps:

  • First, go to the Review tab in your ribbon.
  • Now, from the Protect group, select Unprotect Sheet.

how to remove password from excel file

  • As a result, a box named Unprotect Sheet will appear. Now put in the password of your spreadsheet (“exceldemy” if you are using the one from the download section).

how to remove password from excel file

  • After that, click on Ok.

This will remove the password from the spreadsheet in the Excel file. You can now edit the spreadsheet again to your liking.


Things to Remember

  • Using the Save As feature method will save a different copy of the file without any password. The original file will stay password protected.
  • For all the methods, except the last one, you need to remember the password.
  • The conversion method only works if spreadsheets are password-protected, not the files.
  • Always back up your file before changing the extension of your files, in case the files get corrupteAlways be careful while selecting the line during removing it from the text file in the last method. Selecting extra portions or lesser ones may corrupt the file.

Download Practice Workbook

You can download the workbook used for demonstration here and practice yourself while you go through the steps described in each process. Use “exceldemy” as a password.


Conclusion

These are all the methods you can use to remove the password from the Excel file. Hope you have found this guide detailed enough to be helpful and informative. If you have any questions or suggestions, let us know below.


Related Articles


<< Go Back to  Unprotect Workbook in Excel | How to Unprotect in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Abrar-ur-Rahman Niloy
Abrar-ur-Rahman Niloy

Abrar-ur-Rahman Niloy, holding a B.Sc. in Naval Architecture and Marine Engineering, has contributed to Exceldemy for nearly 1.5 years. As a leader in Excel, VBA, and Content Development teams, he authored 114+ articles and assisted the Exceldemy forum. Presently, as a project writer, he prioritizes stepping out of his comfort zone, aiming for constant technical improvement. Niloy's interests encompass Excel & VBA, Pivot Table, Power Query, Python, Data Analysis, and Machine Learning libraries, showcasing his commitment to diverse... Read Full Bio

2 Comments
  1. Sorry! for me not working …
    I have follow you suggest using change extension to zip from xlsx but result file crashed and not open

    • Dear Amedeo,
      Perhaps you are trying to break the file level protection. Unfortunately, the Zip method can only break the password on worksheet level or workbook level protection. Although this information may not have been highlighted earlier, is now included in a Note.
      Regards
      Aniruddah
      Team Exceldemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo