How to Remove Password from Excel

by

Removing a password from an Excel file can be necessary if you need to access or edit the file without entering a password. This guide will walk you through several methods to remove passwords from Excel files, depending on your situation.

Method 1: Using the Info Panel

  1. Open the Excel File: Launch Excel and open the file that is password-protected.
  2. Enter the Password: When prompted, enter the password to unlock the file.
  3. Go to the Info Panel: Click on the “File” tab in the top-left corner.
  4. Select Protect Workbook: Click on “Info” in the left-hand panel.
  5. Remove Password: Click on “Protect Workbook” and then “Encrypt with Password”. Delete the password in the field and click “OK”1.
  6. Save the File: Save the changes and close the file.

Method 2: Using Save As Option

  1. Open the Excel File: Open the password-protected Excel file.
  2. Enter the Password: When prompted, enter the password to unlock the file.
  3. Go to Save As: Click on the “File” tab and select “Save As”.
  4. Remove Password: In the Save As dialog box, click on “Tools” and then “General Options”.
  5. Clear Passwords: In the General Options dialog box, delete the text in the “Password to open” and “Password to modify” fields.
  6. Save the File: Click “OK” and then “Save” to save the file without a password.

Method 3: Using Zipping an Excel File

  1. Enable File Extensions: In File Explorer, go to the “View” tab and check the box for “File name extensions”.
  2. Change File Extension: Right-click on the Excel file and select “Rename.” Change the file extension from .xlsx to .zip.
  3. Extract the Zip File: Double-click the .zip file to open it.
  4. Edit the XML File: Navigate to the “xl” folder and open the “workbook.xml” file in Notepad.
  5. Remove Password: Use the search function (Ctrl + F) to find the password protection line. Delete the entire line and save the changes1.
  6. Recompress the Zip File: Save the changes in Notepad and close it. Compress the folder back into a .zip file1.
  7. Change File Extension Back: Rename the .zip file back to .xlsx.

Method 4: Using Online Tools

There are several online tools that can help you remove passwords from Excel files. One such tool is Clideo1.

  1. Visit Clideo: Go to the Clideo website and select the “Mute Video” tool.
  2. Upload Your File: Upload the Excel file from your computer or a cloud storage service.
  3. Remove Password: Clideo will automatically remove the password from the file.
  4. Download the File: Save the password-free Excel file to your computer.

Important Considerations

  • Security Risks: Removing passwords from Excel files can make them vulnerable to unauthorized access. Ensure that your files are stored securely.
  • Password Recovery: If you have forgotten the password, you may need to use specialized software or services to recover it before removing it.
  • Compatibility: Some methods may not work with all versions of Excel. Ensure that your software is up to date.

Leave a Comment