Many Excel users know how to protect their spreadsheets with a password, but only a few would know how to remove a password from an excel spreadsheet. Knowing this is as important as knowing how to put a password as there may be some odd cases where you would want to remove the password from the spreadsheet.

People who are not good with remembering passwords need to learn how to remove passwords from the excel sheet before it gets permanently locked, Also, people who hate to put passwords every time they open the spreadsheet would also like the password to be removed. In short, learning the technique to remove a password from an excel spreadsheet can come handy. If you know it already then great, if not, here is how you can do it.

Removing the Password Through the Save As Method:

This part of the article will explain how to remove an excel spreadsheet password through the Save As method. The second method is much similar to that. However, they both are different and hence, this article tends to cover both of them separately. Here is how to do it via the first method.

1. Go to the location where you have saved the protected excel spreadsheet and open it from there.

2. Upon opening the sheet, you will be asked to provide the password to proceed. Key in the password and hit OK.

3. Click on the option File from the menu bar and then click on the option Save As. Now choose the location where you want to save the file after removing the password.

4. Before hitting Save, click on the option Tools which is located beside the option Save.

5. Upon clicking Tools a dropdown would open. Choose the option General Options from it.

6. Now a dialogue box would appear. You will need to clear the field next to the option Password to Open and then hit OK. Do not key in anything next to the field Password to Modify.

7. Save the file and you won’t need to provide the password the next time you open it.

Removing the Password Through the Info Tab:

1. Go to the location where you have saved the protected excel spreadsheet and open it from there.

2. Upon opening the sheet, you will be asked to provide the password to proceed. Key in the password and hit OK.

3. Click on the option File on the menu bar followed by clicking on the Info tab.

4. Now click on Protect Workbook and in the drop-down menu click Encrypt with Password.

5. A dialogue box would appear on the screen. You just need to clear the password field and then hit on the option OK.

6. Now you will need to save the file. You wouldn’t need to key in the password the next time you open the spreadsheet.

So, this is how easy it is to remove the password from an excel spreadsheet. Things may be a little difficult if you are unable to recall the password. You may need to reset it or you may have to take assistance from a third-party tool to crack it. Anyway, protecting the spreadsheets is important as they usually have important financial data. However, if no one other than you have access to your device then you can leave it unprotected as well.