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.

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

• 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.

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

• 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.

• 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

• How to Remove Data Validation in Excel (5 Ways)
• Remove Table Formatting in Excel (2 Smart Ways)
• How to Remove Timestamps from Date in Excel (4 Easy Ways)
• Data clean-up techniques in Excel: Fixing trailing minus signs