How to Remove Password from Excel 2010 with/without Password

author_icon Ronnie Barnes time_icon Last updated: Oct 15, 2019 03:08 pm tips_icon Excel

With most of our work done and shared online, the threat of cybercrime has made it necessary for us to protect the information we share. One of the easiest ways to protect information is to use password or passkey. Strong passwords can make it virtually impossible for someone without the key to access the data. It is clear that Microsoft also sees cyber security as an important issue seeing as there is a password feature for every product they develop.

The password feature in Microsoft Excel 2010, in particular, provides an effective way to ensure that the data on the worksheet remains safe. Yet, it is very easy to lose a password or forget it which can leave you scrambling for this important data yourself. Fortunately, there are ways to remove password from Excel 2010 and in this article we are going look at the various ways you can do that.

Method 1. Remove Password from Excel 2010 with Known Password

If you know the password used to lock the Excel 2010 document, then there are several ways to remove the password with the password.

Opening Password

An opening password refers to the password used to lock the document and keep it from opening. If an opening password is set on a workbook or document, a popup will appear every time you try to open the document, requesting that you enter the password to unlock the program. Here's how you can remove this opening password to prevent the popup from appearing:

Step 1: Once you've opened the Excel workbook, go to File > Info > Protect Document > Encrypt with Password. You should see a dialogue box with the old password in it.

opening password

Step 2: Simply clear the password from the field and click "OK". This will remove the password and render your document successfully decrypted.

Modifying Password

Modifying password is different from the opening password. If you don't know the Modify password, you may still be able to open the document and read it, you just won't be able to edit it. You may also have heard it called the "Edit Restriction Password". Here's how to remove the modifying password.

Step 1: Open the Excel document in question and then go to File > Info > Protect Document > Restrict Editing.

restrict editing

Step 2: You should see the "Stop Protection" button at the bottom of the page on the "Restrict Editing" section. Click on this option and the modify password will be removed.

Worksheet Password

The worksheet password is a password that prevents any user without the password from moving, changing or deleting any data on the worksheet. This password is special in that it allows you to make only certain parts of the sheet editable so that users will only be able to change data on these regions and not others. If you want to remove this password, the following is how to do it:

Step 1: Open the Excel document with the worksheet password encryption and then click on "Review" on the main menu.

Step 2: Next, click on "Unprotect Sheet" and that's it.

unprotect sheet

Step 3: Enter the password in the next window and click "OK" to remove the encryption.

Workbook Structure Password

The workbook structure password prevents people without the password from moving, deleting, renaming or adding new worksheets to the workbook, thereby protecting the structure of the workbook. It is also worth noticing that this password will only protect the structure of the workbook and not the content. If you would like to remove this restriction, here's how to do it.

Step 1: Open the Excel document and then go to File > Info > Protect Document >Protect Workbook Structure.

Step 2: Enter the password in the dialogue box that appears and save the document as you normally would.

workbook structure password

The workbook structure will be removed and you can now edit the entire workbook as you want.

Read-Only Password

The Read-Only mode helps you to protect the document from accidental modification. As the name suggests, anyone looking at a Read-Only document will only be able to read the document and not edit it in any way. If you have a read-only workbook that you want to edit, the following is what to do.

Step 1: Open the document and it will either open or ask if it should open in read-only mode.

Step 2: Once it is open, go to File > Info > Protect Document > Always Open read-only mode and the restrictions on the document will be immediately lifted.

always open read only

Method 2. Remove Password from Excel 2010 If You Forgot the Password

If on the other hand you don't know or have forgotten the password for the Excel 2010 document, the only option you have is to recover the password and then use it to unlock the document. Fortunately for you, we have a solution that is always successful in this endeavor.

2.1 Remove 'Password to Open' for Excel 2010

The best ways to recover an opening password for an Excel document is to use a program specifically designed for this purpose. One of the best tools for this purpose is Passper for Excel, a password recovery tool that is highly effective in helping you recover any opening password and remove all restrictions placed on an Excel document in a single click. To do this, Passer for Excel employs the following features:

  • It allows you to unlock the password in various scenarios including if you have forgotten the password, can't copy or edit the workbook or worksheet, can't edit the content on the document or you can't print the document.

  • It utilizes 4 very powerful attack modes to recover your password, thereby becoming one of the most powerful recovery tools with the highest recovery rate.

  • It can also unlock Excel spreadsheet, making it easier for you to open and edit any Excel document without password.

  • Above all, it is very easy to use. The whole process of recovering the password can be done in just 3easy steps.

Free Download for Win 10/8.1/8/7/XP

To use Passper for Excel to recover the opening password for any Excel document, follow these simple steps:

Step 1: Download and install Passper for Excel on your computer and then launch the program. On the main window, select "Recover Passwords".

recover password step1    

Step 2: Now click "Add" to browse your computer for the protected file and add it to the program.

Choose an attack mode from the 4 presented. Each of the attack modes is designed to help you figure out the password depending on the complexity of the password.

recover password step2    

Step 3: As soon as the attack mode is selected, the program will begin the recovery process and after a few minutes, the password will be displayed on the screen. You can click on "Copy" to place the password on your clipboard to use later.

recover password step3    

2.2 Remove 'Password to Modify' for Excel 2010 Worksheet

Passper for Excel can also be very handy when you want to remove the restrictions from an Excel document. To remove these restrictions and have access to the whole document, follow these simple steps:

Free Download for Win 10/8.1/8/7/XP

Step 1: Open Passper on your computer and then choose the "Remove Restrictions" mode.

remove restrictions step1

Step 2: Click "Add" to browse for the restricted document and add it to the program.


Step 3: Once the document is added in Passper, click on "Remove" and the program will easily remove all restrictions on the Excel sheet, making it easy for you to edit it.


Method 3. Remove Password from Excel 2010 Online

There are a lot of online tools that can also come in handy when you want to remove password from Excel 2010 document. Many online tools utilize a brute force type attack to remove the password. Here's how to use an online tool to crack an Excel password:

Step 1: Open any browser on your computer and search for a program that offers this service. There are very many.

Step 2: Once you locate one, upload the password-protected Excel document on to the website. Make sure that you read the fine print since some online tools don't support earlier versions of Excel.

Step 3: When requested, enter your email address and wait for the recovery process to be completed. Once the password has been recovered, you will receive an email with the password that you can use to open the document.


There are very many ways to remove password from Excel 2010 document, all of which may come in handy when you want to keep the information away from prying eyes. But as we have seen through the course of this article, there are also several ways you can bypass this restriction and gain access to a protected Excel 2010 document without password.


By Ronnie Barnes to Excel

Posted on May 20, 2019 ( Updated: Oct 15, 2019 )

Ronnie Barnes, a blogger with more than 5-year experience in writing tips about password recovery for Windows and office files.