How to Set, Reset, Remove and Recover the Password of Excel Files

Download Article

Encrypt and protect your Excel spreadsheets easily

Author Info

Last Updated: March 21, 2025

Download Article

• Setting an Excel File Password
|
• Resetting a Password
|
• Removing a Spreadsheet Password
|
• Removing a Password Online
|
• Recovering a Password with Dossoft Password Rescuer
|
• Video
|
• Tips

|Show more |Show less

It is crucial to protect a company or individual sensitive data in today’s highly connected world. Excel documents containing data such as payroll information, trading algorithms, confidential information or company secrets should always be password protected alongside normal document protection. However, these seem not far enough. We can do nothing but feel anxiety if the data is locked in Excel.

For this reason, some professional teams designed Excel password rescuer tools to recover Excel passwords for those who have lost or forgotten them. See Method 4.

Steps

Method 1

Method 1 of 5:

Setting a Password for an Excel File

Download Article

1. 
   1
   Click on the Office button, select Prepare, and then choose Encrypt Document
2. 
   2
   Enter a password in the Password box and then press OK.
   Advertisement
3. 
   3
   Re-enter the previous password to confirm and then press OK.
4. 
   4
   Save the password and the MS Excel 2007 document.(Note: As Microsoft advises, you must not forget the password or you will not be able to get into the document. If you forget, you have to turn to third-party software like Excel password rescuer for help.)
Advertisement

Method 2

Method 2 of 5:

Resetting the password of An Encrypted MS Excel 2007 Document

Download Article

1. 
   1
   Click on the Office button-> Save as-> Tools on the right bottom of the Save as dialog box.
2. 
   2
   Click the Tools menu and choose General Options.
3. 
   3
   Type a password in the modifying password blank.
4. 
   4
   Retype the precious password in the blank and then press OK.
5. 
   5
   Click Save.
Advertisement

Method 3

Method 3 of 5:

Removing the Password of an Excel Spreadsheet

Download Article

1. 
   1
   Enter the password to open the spreadsheet.
2. 
   2
   Click on the Office button-> Prepare-> Encrypt Document.
3. 
   3
   Remove the punctiform password in Encrypt Document box and then click OK.
4. 
   4
   Save the spreadsheet.
Advertisement

Method 4

Method 4 of 5:

Removing an MS Excel File Password Online

Download Article

1. 
   1
   Find an online password recovery service using query "password find online"
2. 
   2
   Press the Unprotect your file button
3. 
   3
   Press the Browse button, select your protected spreadsheet and click Next Step
4. 
   4
   Select recommended Remove password option
5. 
   5
   Wait a few seconds while your password is being removed
6. 
   6
   If your file is small, it will be unprotected for free!
7. 
   7
   For bigger files you’ll be able to see the first rows of all your spreadsheets. To get the full document, you’ll need to enter the license key.
Advertisement

Method 5

Method 5 of 5:

Recovering MS Excel password with Dossoft Excel Password Rescuer

Download Article

1. 
   1
   Download Excel Password Rescuer and install it.
2. 
   2
   Click Open and select the file of which the password is lost.
3. 
   3
   Choose an attack type to recover Excel password.
4. 
   4
   Attack settings.
5. 
   5
   Click Start on the left top. When the operation is finished, you will recover the lost Excel password successfully.
Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Video

Tips

• Excel Password Rescuer is one of the most popular Excel password recovery tools that can recover Excel password from Excel 97 to Excel 2013. Meanwhile, it can open your file without any deficiency.
  Thanks

  Helpful 0 Not Helpful 0

Submit a Tip

All tip submissions are carefully reviewed before being published

Name

Please provide your name and last initial

Submit

Thanks for submitting a tip for review!

Advertisement

You Might Also Like

1

How to

Set, Reset, & Remove Password Protection of a Word File

2

How to

Password Protect a Microsoft Excel Spreadsheet

3

Microsoft Excel: 2 Ways to Open a Password Protected Spreadsheet

4

How to

Unprotect an Excel Sheet

5

How to

Lock Cells in Excel

6

Easy Ways to Encrypt Your Sensitive Word Documents with a Password

7

How to

Remove a Password from a Word Document

8

How to

Send Documents Securely on PC or Mac

9

4 Easy Ways to Password Protect Files on Mac

Expert

10

How to

Make a Computer Diary

11

How to

Password Protect a PDF

12

How to

Change an Excel Sheet from Read Only

13

How to

Secure a PDF Document from Copying and Editing

14

3 Easy Ways to Protect a Folder With a Password

Advertisement