How to Remove Password from Excel (3 Simple Ways)

Sometimes it is really crucial to secure our important files with passwords temporarily. But when it’s time to extract the important files again without interruption, we need to remove the password to work smoothly. In this article, you will learn how to remove a password from Excel in 3 quick and easy ways.


Download Practice Template

Attached here is a password-protected Excel file so that you can download it and practice.

password: 987654321


3 Easy Ways to Remove Password from Excel

In this section, we will show you 3 different ways of removing passwords from Excel by using Excel’s Info feature, from the Home tab and with the Save As option.

1. Using the Info Feature to Remove Password from Excel

Steps to remove passwords from Excel using the Info feature are shown below.

Steps:

  • Open the password-protected Excel file.
  • Click on the File tab from the Excel Ribbon.
  • Next select Info -> Protect Workbook -> Encrypt with Password.

info feature to remove password from excel

  • A pop-up Encrypt Document window will appear with your encrypted password in the Password box. Remove the password.

remove password from excel with info feature

  • Keep the Password box blank and click OK.

This will remove the password from the Excel workbook.


2. Home Tab to Delete Password from Excel

Steps to remove passwords from Excel with the Home tab are given below.

Steps:

  • Open the password-protected Excel file.
  • In the Home tab, go to Format -> Unprotect Sheet.

remove password from excel from home tab

  • A pop-up Unprotect Sheet window will appear with your encrypted password in the Password box. Remove the password.

remove password from excel with format tool

  • Keep the Password box blank and click OK.

This will remove the password protection of your Excel workbook.


3. Remove Password from Excel with Save As Option

Steps to remove passwords from Excel using the Save As option are given below.

Steps:

  • Open the password-protected Excel file.
  • Click on the File tab from the Excel Ribbon.
  • Select Save As. It will open the Save As window.
  • Click on Tools -> General Options.

remove password from excel with save as option

  • A pop-up General Options window will appear with your encrypted password in the Password to open option. Remove the password.

  • Keep the options Password to open and Password to modify blank. Click OK.

This will delete the password from the Excel workbook.


Conclusion

This article showed you how to remove a password in Excel in 3 easy and quick ways. I hope this article has been very beneficial to you. Feel free to ask any questions regarding the topic.


You May Also Like to Explore

Sanjida Ahmed

Sanjida Ahmed

Hello World! This is Sanjida, an Engineer who is passionate about researching real-world problems and inventing solutions that haven’t been discovered yet. Here, I try to deliver the results with explanations of Excel-related problems, where most of my interpretations will be provided to you in the form of Visual Basic for Applications (VBA) programming language. Being a programmer and a constant solution seeker, made me interested in assisting the world with top-notch innovations and evaluations of data analysis.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo