How To Remove Password From Excel?

Learn how to remove password from Excel to edit the data in the workbook and share it with others. It is a good habit to protect an Excel file with a password. This helps you to manage who can approach or edit your files. Nobody can access the file unless you share the password or remove the password. In today’s post, I will show you how to remove password from Excel workbook. It is better to remove the password from an encrypted Excel spreadsheet if you frequently work on it to save time. Here are some methods you can try to learn how to remove password from Excel.

How To Remove Password From Excel?

In this section, I will teach you how to remove password from Excel. Adding a password to your Excel worksheet helps you to add an extra layer of security. This feature is useful for preserving sensitive information like financial reports. You can remove the Excel password any time you want.

Follow these steps to know how to remove a password from Excel.

  1. Open the Excel file that contains the password protection.
  2. An enter password pop-up window will appear on your screen.
  3. Enter the spreadsheet password and click on the OK button.
  4. Go to the File tab and select Info from the left pane.
  5. Then, click on Protect Workbook to view its drop-down menu.
  6. Here, select the Encrypt with Password option.
  7. This will bring up the Encrypt Document dialog box.
  8. Remove the password from the Password section so the text box is blank.
  9. Lastly, click on the Ok button to close this pop-up window.

You can use the same steps to remove password from Excel 2016. To remove the password of an Excel spreadsheet, you must know the current password. Otherwise, you won’t be able to open the document to make these changes. 

Remove Password From Excel Using Home Tab

With the help of Excel’s Home tab, you can remove the encryption from the Excel file. Follow these steps to learn how to remove password protection from Excel.

  1. Open the Excel file that contains the password protection.
  2. Then, go to the Home tab on the main ribbon menu.
  3. Navigate to the Cells group.
  4. Here, click on the Format drop-down arrow.
  5. From this list, choose Unprotect Sheet.
  6. Now, enter the password and click on the OK button.

Thus, this will immediately clear the password of the selected encrypted Excel sheet.

You can keep on reading further to know more about how to remove password from Excel Windows 10.

Remove Password From Excel From Review Tab

You can even remove the password from an Excel spreadsheet from the Review tab. Follow these steps to know how to remove password from Excel file without opening it.

  1. Open the Excel file that contains the password protection.
  2. Then, go to the Review tab and select Protect Sheet.
  3. Now, enter the password in the given password text box.
  4. Click on the Unprotect Sheet option to remove the password.

However, you can even remove a password from the workbook. Simply click on Protect Workbook >> enter the password >> click on Unprotect Workbook.

You can use the same method to remove password from Excel Online for free.

Remove Password From Excel Using Save As Feature

Surprisingly, you can even remove passwords from Excel files using the Save As feature. Follow these steps to learn how to remove password from Excel workbook Office 365.

  1. Open the encrypted Excel file.
  2. Then, enter the file password and click on OK.
  3. Go to the File tab and choose the Save As option from this menu.
  4. Now, choose a folder and you’ll see a new window open.
  5. Click on the Tools drop-down arrow.
  6. Choose General Options.
  7. This will bring up the General Options dialog box.
  8. Here, remove the passwords from the given text fields.
  9. Then, click on the Ok option.
  10. Finally, click on the file menu and select Save.

Make sure you remove passwords from both text fields; Password to Open and Password to Modify.

Remove Password From Excel 2007

If you don’t need a password to protect your Excel file, you can remove it. Follow these steps to learn how to remove password from Excel 2007.

  1. Open the Excel file that contains the password protection.
  2. Then, go to the Review tab.
  3. Under the Protection section, select Passwords.
  4. This will bring up the Password to Open or Password to Modify dialog box.
  5. Over here, select all the contents.
  6. Now, press the Delete button and click on Save.

Once you save the document, it won’t be protected by any password.

Remove Password From Excel Mac

You can also remove a password from an Excel sheet on Mac. Follow these steps to learn how to remove password from Excel Mac.

  1. Open the Excel file that contains the password protection.
  2. On the desktop’s menu bar, click on File.
  3. Select Passwords from the drop-down menu.
  4. This will bring up the File Passwords dialog box.
  5. Now, delete the password from each text box.
  6. Click on OK to save the workbook.

Make sure you leave each text box; Password to Open and Password to Modify blank and then click on OK.

Remove Password From Excel Without Knowing Password

Things go a bit easier when you know the password of your encrypted Excel file. But it can get complicated when you lost it!

You can follow these steps to know how to remove password from Excel without password.

  1. Before you start, make a copy of the password-protected Excel file.
  2. Now, open the copy of the file with the 7-Zip program.
  3. Here, open the xl folder and then the worksheets folder.
  4. Right-click on your Excel file (sheet1.xml) and select Edit.
  5. Or else select your Excel file and press F4.
  6. Your Excel file will now open in the Windows editor.
  7. Here, find the XML entry “sheetProtection”.
  8. Delete the entry from “<sheetProtection” to the next”/>”.
  9. Select Save and close the Windows editor.

Open the modified copy of the file in Excel and check if the sheet protection has been removed.

You can search for more different topics on Remowz

FAQ

How Do I Remove A Password From An Excel File Without Password?

Just do any of the following:

  1. Right-click the sheet tab, and select Unprotect Sheet… from the context menu.
  2. On the Review tab, in the Changes group, click Unprotect Sheet.
  3. On the Home tab, in the Cells group, click Format, and select Unprotect Sheet from the drop-down menu.

How Do You Remove Password And Read Only From Excel?

Unlocking a Locked Excel File on a PC

  1. From Explorer, search for the Excel File in question.
  2. Right-click on the Excel file you want to edit.
  3. Select Properties.
  4. Go to the bottom of the General Tab.
  5. Uncheck the Read Only check box.
  6. Click OK to finalize.

How Do I Unlock A Protected Excel Spreadsheet?

To unprotect a sheet, follow these steps: Go to the worksheet you want to unprotect. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.

Why Can’t I Remove Password From Excel?

On the info page, click on the “Protect Workbook” box. Select the “Encrypt with Password” button from the drop-down menu. Delete the password from the pop-up window that appears so the text box is blank. Then, click the “OK” button to remove the password from your Excel spreadsheet.

What Is The Shortcut To Unlock An Excel Spreadsheet?

Simply select the cells you want to change and press the Ctrl + 2 keys to unlock them. Then make your changes and lock the cells again when you’re done. These shortcuts are a quick and easy way to lock or unlock cells in Excel.

Can I Unlock A Locked File?

Sometimes when you try to delete, rename or move a file in Windows, you may see a message that the file is busy/locked/used by another process. Usually the name of the program that keeps the file open is shown right in the File Explorer message window. To unlock the file, it is enough just to close the program.

Conclusion

In the above post, I’ve discussed how to remove a password from an excel file in detail. You can remove the password of your Excel workbook anytime if you think it is unnecessary. On Windows, open the workbook >> enter Password >> File >> Info >> Protect Workbook >> Encrypt with Password. Over here, delete the password from the textbox and click OK. When it comes to how to remove passwords from Excel online, use the Review tab method. Always keep in mind that anyone can access the workbook once you remove the password. By learning how to remove password from Excel, you can access any password-protected worksheets.