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

This updated guide examines How to Set, Reset, Remove and Recover the Password of Excel Files and organizes the essential facts, background, and practical takeaways in clear American English.

Responsible-use note: Apply security techniques only to systems you own or are explicitly authorized to test.

Method 1

Setting a Password for an Excel File (taking Excel 2007 for example)

1. Click on the Office button, select Prepare, and then choose Encrypt Document
2. Enter a password in the Password box and then press OK.
3. Re-enter the previous password to confirm and then press OK.
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 forget, you have to turn to third-party software like Excel password rescuer for help. )

Method 2

Resetting the password of An Encrypted MS Excel 2007 Document

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

Method 3

The way to Remove the Password of an Excel Spreadsheet

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

Method 4

The way to recover MS Excel password with Dossoft Excel Password Rescuer

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