How To Remove A Password From Excel

To remove a password from an Excel file, you need to open the file, navigate to the File menu, select Info, click on Protect Workbook, and choose Encrypt with Password; afterward, delete the password and click OK to save changes. Successfully remove the password from the Excel file.

In today’s digital age, password protection has become an essential tool for securing sensitive information. Excel, as one of the most widely used spreadsheet software, offers the ability to use passwords to protect important data. However, there may come a time when you need to remove a password from an Excel file. Whether you have forgotten the password or no longer require the additional security, knowing how to remove a password from Excel is a valuable skill. In this blog post, we will guide you through the process step-by-step, ensuring that you can regain access to your Excel file without any hassle.

How To Remove A Password From Excel: Step-by-Step


Step 1: Open the Document,

To remove the password protection from an Excel file, locate and open the specific file in which you want to remove protection. This will give you access to the file’s contents and settings.

Next Step

Step 2: Enter the Correct Password,

If your file is password protected, you must input the correct password when prompted by the system. This will grant you access to the file’s contents, ensuring its security and preventing unauthorized individuals from viewing or editing the information.

Next Step

Step 3: Access File Menu,

Once you have successfully accessed your document, you can easily find the ‘File’ option at the top-left corner of the Excel user interface, which allows you to access various document-related features and settings.

Next Step

Step 4: Choose Protect Workbook,

Once you click on the ‘File’ button, navigate to the dropdown menu and select ‘Protect Workbook’ to access Excel’s comprehensive security features for managing your file’s protection measures.

Next Step

Step 5: Choose Encrypt With Password,

After selecting ‘Protect Workbook’, a dropdown menu will appear where you can further enhance security by choosing ‘Encrypt with Password’.

Next Step

Step 6: Remove the Password,

After opening the ‘Encrypt Document’ window, you will notice encrypted dots representing your password. Easily remove these dots/characters by pressing the backspace or delete key, ensuring they are completely erased.

Next Step

Step 7: Save Your Document,

After removing the password, click ‘Ok’ to confirm. Remember to save your document through the ‘Save’ option in the ‘File’ menu to preserve the changes.


Removing a password from an Excel file can often be a necessity when you find yourself unable to access or modify important data. Luckily, there are a few tried and tested methods available for users to choose from. Whether it is through the use of built-in Excel features, VBA scripts, or third-party tools, the process can be accomplished with relative ease. However, it is important to remember that password protection is designed as a security measure, and attempting to remove a password without proper authorization may be illegal or unethical. Always ensure you have the necessary rights before proceeding. Nonetheless, armed with the knowledge provided in this blog post, you now have the ability to regain control over your password-protected Excel files and continue working without any hindrances.

Table of Contents