How to Take Password Off Excel: A Comprehensive Guide to Unlocking Files

Everyone has been there: you set a password on an Excel file to keep it secure, and then you either don’t need the password anymore or, oops, you forgot it. Relax! Removing a password from an Excel sheet is a straightforward process. Let’s walk through how to do it step by step so you can regain access to your precious data without any headaches.

How to Take Password Off Excel

Unlocking an Excel file might sound like a complex task, but it’s quite simple once you know the steps. Here’s how to do it:

Step 1: Open the Excel File

First, open the Excel file that you want to remove the password from.

To do this, you need to remember the current password. If you have forgotten it, you might need some specialized tools to recover it, but that’s a topic for another day.

Step 2: Enter the Password

Next, enter the current password to access the file.

Make sure you enter the password correctly. If you make a mistake, the file won’t open, and you’ll need to try again.

Step 3: Go to File Menu

Click on the ‘File’ tab at the top-left corner of the screen.

This will open up the file menu where you’ll see various options like Save, Save As, and others.

Step 4: Click on ‘Info’

From the File menu, click on ‘Info’.

This section provides details about your file, like size, last modified, and importantly, protection settings.

Step 5: Select ‘Protect Workbook’

Click on ‘Protect Workbook’ and then select ‘Encrypt with Password’.

Here, you’ll be able to see the current password settings for your workbook.

Step 6: Delete the Password

In the dialog box that appears, delete the current password and then click ‘OK’.

By deleting the password and confirming, you are effectively removing the protection from your workbook.

Step 7: Save the File

Finally, save the file to make sure your changes are applied.

You can either save it directly or use ‘Save As’ to create a new file without a password.

After completing these steps, your Excel file will no longer require a password to open. This can save you a lot of time and effort, especially if you frequently access the file.

Tips for Taking Password Off Excel

  • Keep a Backup: Always make a backup of your file before making changes. Better safe than sorry!
  • Use Strong Passwords: If you decide to keep a password, make sure it’s strong and memorable.
  • Remember the Password: Write it down somewhere secure if you think you’ll forget it.
  • Use Excel Versions Wisely: Different Excel versions might have slightly different steps, so always check the version you’re using.
  • Seek Professional Help: If you’re stuck, there are professional tools and services to help you recover or remove passwords.

Frequently Asked Questions

Can I remove the password if I don’t know it?

Unfortunately, you need to know the current password to remove it. Specialized tools can help recover lost passwords, but they aren’t foolproof.

What if I forget to save after removing the password?

You’ll need to go through the steps again. Always remember to save your changes!

Can I remove the password on a shared Excel file?

Yes, but make sure it’s okay with everyone using the file. Removing the password will make the file accessible to anyone.

Is there any risk in removing the password?

Once the password is removed, anyone with access to the file can open it. Make sure your file doesn’t contain sensitive data.

What versions of Excel does this work on?

These steps work on most modern versions of Excel, including Excel 2010, 2013, 2016, and beyond.


  1. Open the Excel File
  2. Enter the Password
  3. Go to File Menu
  4. Click on ‘Info’
  5. Select ‘Protect Workbook’
  6. Delete the Password
  7. Save the File


Unlocking an Excel file by removing its password doesn’t have to be a daunting task. Whether you’re doing it because you no longer need the security or simply forgot the password, following these easy steps will get you there. Just remember, while it’s convenient to have files without passwords, you should always weigh the security risks. If you decide to keep using passwords, make them strong and memorable. For more advanced issues, like password recovery, there are specialized tools and professionals who can assist. Keep exploring, stay safe, and happy Excel-ing!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy