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

PDF download Download Article
PDF download Download Article

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.

Method 1
Method 1 of 5:

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

PDF download Download Article
  1. Step 1 WH.performance.clearMarks('image1_rendered'); WH.performance.mark('image1_rendered');...
    Click on the Office button, select Prepare, and then choose Encrypt Document
  2. Step 2 Enter a password in the Password box and then press OK.
    Advertisement
  3. Step 3 Re-enter the previous password to confirm and then press OK.
  4. Step 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.)
    5. Advertisement
Method 2
Method 2 of 5:

Resetting the password of An Encrypted MS Excel 2007 Document

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

Removing the Password of an Excel Spreadsheet

PDF download Download Article
  1. Step 1 Enter the password to open the spreadsheet.
  2. Step 2 Click on the Office button-> Prepare-> Encrypt Document.
  3. Step 3 Remove the punctiform password in Encrypt Document box and then click OK.
  4. Step 4 Save the spreadsheet.
    5. Advertisement
Method 4
Method 4 of 5:

Removing an MS Excel File Password Online

PDF download Download Article
  1. Step 1 Find an online password recovery service using query "password find online"
  2. Step 2 Press the Unprotect your file button
  3. Step 3 Press the Browse button, select your protected spreadsheet and click Next Step
  4. Step 4 Select recommended Remove password option
  5. Step 5 Wait a few seconds while your password is being removed
  6. Step 6 If your file is small, it will be unprotected for free!
  7. Step 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.
    8. Advertisement
Method 5
Method 5 of 5:

Recovering MS Excel password with Dossoft Excel Password Rescuer

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

Expert Q&A

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

Password Protect an Excel Spreadsheet
How to
Password Protect a Microsoft Excel Spreadsheet
Recover a Corrupt Excel File
How to
Recover a Corrupt Excel File
Unprotect a Word Document Without the Password
How to
Unprotect a Word Document Without the Password
Get Microsoft Office For Free7 Ways to Use Microsoft Office for Free: Web, Mobile, & Desktop Versions
Transfer Microsoft Office to Another ComputerA Complete Guide to Transferring MS Office to a New Computer
Strikethrough in OutlookStrike Through Text Easily in any Outlook Email Message
Install Microsoft Office
How to
Install Microsoft Office: Subscribe and Download
Change Transparency in PowerPoint
How to
Adjust Image and Object Transparency in PowerPoint
Send a Delayed Email in Outlook
How to
Schedule an Email Message in Microsoft Outlook
Duplicate a Page in WordA Complete Guide to Duplicating Pages in Word
Print Mirror Image
How to
Print Mirror Image
Send Large Files Through Outlook
How to
Attach Large Files & Folders to Emals in Outlook
Upgrade Microsoft Office
How to
Upgrade Microsoft Office
Install Microsoft Teams on Windows
How to
Install Microsoft Teams on Windows: Work, School, & Personal
Advertisement

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 15 people, some anonymous, worked to edit and improve it over time. This article has been viewed 102,831 times.
How helpful is this?
Co-authors: 15
Updated: March 9, 2021
Views: 102,831
Categories: Microsoft Office
Thanks to all authors for creating a page that has been read 102,831 times.

Is this article up to date?

Advertisement