How to Remove a excel sheet Password

Priya BhadaurjaAugust 3, 2022

0 376

Table of Contents

How to Remove a excel sheet Password if you know the Password- You can remove the password for the Excel sheet by following a few easy steps whether you set it or if you received it via email.

How to Remove a excel sheet Password from Info panel

Start by opening the password-protected Excel file that you wish to erase.
After entering the Excel password, tap OK.
Go to the File tab in the top left corner of the Excel spreadsheet.
To access the drop-down menu, select Info and Protect Workbook on the left-hand panel.
In the drop-down box, choose Encrypt with password, and then remove the password from the text field.
Remove the old password and choose OK.
Select Save from the File menu.

How to Remove Password from the review tab

Start by opening the password-protected Excel file that you wish to erase.
After entering the Excel password, tap OK.
Select the Review tab from the Excel spreadsheet’s main ribbon menu.
Select Unprotect Sheet from the menu, then type the password.
Choose Protect Sheet and click OK without providing a new password to delete the password from the workbook but leave it locked from modification.
Select Save from the File menu.

As an alternative, you may use the Format option to disable the sheet’s protection and delete the password from the Home tab.

How to Remove password using the save as method

Start by opening the password-protected Excel file that you wish to erase.
After entering the Excel password, click OK.
Click the File tab and choose Save As in the upper left corner of the opened Excel file.
After choosing a folder, a pop-up window will show up.
Select Tools from the window’s lower right sidebar. Select General Options from the drop-down menu by clicking it.
A message box titled General Options will pop up and display the encrypted passwords for opening and editing the Excel sheet. Press OK after removing the passwords from both text areas.
Select Save from the File menu.

Mac users

Open the Excel file for which you wish to erase the password.
After entering the Excel password, tap OK.
Click the File tab in the top left corner of the Excel spreadsheet and choose Passwords from the drop-down menu.
A window displaying the encrypted password to open and edit the excel file will show up. Click OK after erasing the passwords from both text areas.
Click Save after selecting the File tab in the navigation bar.

How to remove password from Excel workbook without the password

You can use one of the procedures listed below to open an Excel file if you don’t know the password. If everything else fails, you may also try utilizing third-party software.

Before attempting to erase the password from your Excel files, you should always make a backup copy.

Creating a Zip file from an Excel spreadsheet

You may view a video that details this procedure in detail below. Additionally, I have included all the procedures required to unlock your Excel file’s security without the use of any other software.

Another Method:

Right-click on your document and change the “.xlsx” extension to “.zip” to convert the file.
A warning will appear, requesting your adjustment. Select Yes.
Right-click the zip file and choose Extract All to open its contents.
A popup displaying the folder from which the files will be extracted will appear. Press Extract.
Access the “XL” folder inside the extracted file.
Click the “worksheets” folder inside the “XL” folder.
A list of XML files representing each of the Excel worksheets in your password-protected Excel spreadsheet will be shown. The worksheets are numbered as follows: sheet1, sheet2, etc.
Open an XML file in notepad and look for a line that has the term “protection” to make changes to.
Deleting it will select anything between and up to the “>” and “” characters.
In the notepad, select the File menu and then tap the Save button.
Carry out this procedure for each XML file in the “worksheets” folder of your Excel spreadsheet. Ensure that all XML files have been updated.

Return to the extracted file and pick every file to add your updated XML files back into your zip file.
Click with the right mouse button and choose Send to > Compressed (zipped) folder.
This will produce a fresh zip file. File extensions should be changed from “zip” to “.xlsx”.
A warning will appear, requesting your adjustment. Select Yes.
Open the Excel document.

Now, without having to type a password, you should be able to see and edit the Excel data and information included in your spreadsheet.

How to remove password from Excel workbook using an Online Service

You may also delete passwords from your Excel spreadsheets by using internet tools like Password-Find. The majority of these internet services are compatible with Mac, Windows, Android, Unix, and iOS, unlike third-party applications.

Excel passwords may be deleted using Password-Find–

Please be aware that this is a commercial service, and you might need to buy a licence key in order to acquire a complete copy of your file after the password has been removed.

The Password-Find online service may be used to recover or delete passwords from Excel files.

Visit https://www.password-find.com as step one.
Click Unprotect your file in the upper right corner of the home page.
On the screen for uploading files, tap Browse to choose a file, then tap Next.
There are two alternatives on the next screen. Select the Remove password option to unlock the Excel spreadsheet. Select Find password under the Password Recovery menu.
To change the password or begin the recovery, tap Next step. Based on the password’s strength, removing or recovering it can take some time.
Once finished, the process of unprotection will be visible. When the password is changed, erased, or recovered, you will receive a notice.

How to remove password from Excel workbook using a 3rd Party Software

You can download and install third-party software on your computer to delete passwords from the Excel files whether or not you can recall the password. The ISeePassword Dr. Excel tool is one of these tools.

Website, allows you to download the program.

The best part is that ISeePassword Dr. Excel works with Excel files created in editions 2003 to 2021 and can restore Excel passwords and deactivate worksheet/workbook protect 20+ion without affecting the contents.

Here is a simple tutorial on how to use ISeePassword Dr. Excel to recover or delete the workbook password.

Recover an open password

From the home screen of ISeePassword Dr. Excel, select Recover Open Password from the Excel option.
To import the Excel file that is password-protected, tap the Add File option. Dictionary Attack, Brute-Force with Mask Attack, as well as Brute-Force are the available attack types. Choose Mask Attack as the attack type and choose Brute Force. You may adjust a number of settings using this technique to speed up password recovery.
To configure the correct settings, select the Settings icon on the right side and then click Ok.
To recover the Excel password, tap Start.

The password will then be shown in a new pop-up window.

Select Copy, and then you may use this password to open the Excel file.

Remove the Excel document’s password.

From the main screen of ISeePassword Dr. Excel, select the Remove Workbook, Worksheet Password option.
To import the Excel file that is password-protected, click the Add File button.
To delete the Excel password from the workbook, click the Start button.
After the password has been deleted, a “Remove Finished” notice will appear.

You can utilize additional third-party applications.
If everything else fails, the list of further programs you may download and set up to recover or erase passwords from Excel spreadsheets is provided below:

What will we do next?

I’m hoping that after reading this article you were able to unlock your Excel file’s password. Some techniques operate on Excel from a Microsoft 365 subscription better than others, and some techniques might not function at all. However, be careful to attempt the services suggested in this article if you have forgotten the password to your important file. By discovering the open password without compromising your file, they might save you numerous hours of work.

And always remember to create a complete backup of your Excel file before making any modifications that can lead to data loss.