If you want to remove the password from Excel, here is how you can do that. Whether you want to remove a password or unprotect a sheet, workbook, or spreadsheet, this step-by-step guide can help you get the job done.
Before getting started, you should know that this guide is only for those who remember the password.
How to remove Password from Excel
To remove a password from an Excel spreadsheet or Workbook, follow these steps:
- Open the Excel spreadsheet and enter your password.
- Go to File > Info.
- Click on the Protect Workbook option.
- Click the Encrypt with password option.
- Remove the password and click the OK button.
To learn more about these steps, continue reading.
First, you need to open the Excel spreadsheet and enter your password to access the file. Then, go to File > Info and click on the Protect Workbook option.
Next, click on the Encrypt with password option in the drop-down list.
Here you can find your password that is already being used. You need to remove this password and click the OK button.
Once you do that, the password will be removed immediately.
How to remove password from Excel sheet?
To remove the password from an Excel sheet, follow these steps:
- Open the Excel Workbook and switch to the protected sheet.
- Go to the Review tab and head to the Protect section.
- Click on the Unprotect Sheet option.
- Enter the password and click the OK button.
To know more about these steps, keep reading.
First of all, open the Excel Workbook and switch to the protected sheet that you want to unprotect. Then, go to the Review tab and find the Protect section.
Here you can find an option called Unprotect Sheet. Click on this option and enter the password that was set to protect the sheet.
Click the OK button. Once you do that, your sheet will be unprotected or unlocked. In other words, the password will be removed immediately.
Read: How to remove Read-only from an Excel document?
How to remove Excel password if forgotten?
To remove a forgotten Excel password, you need to use a third-party software called PassFab for Excel. or Passper Excel Password Recovery Tool. They use various methods to remove the password within moments. As of now, there is no other way, or Microsoft doesn’t offer any option to recover the password.
How do I remove password protection from Excel?
To remove password protection from Excel, you need to open the spreadsheet and go to the File > Info section. Then, click on the Protect Workbook option and select the Encrypt with password option from the drop-down list. Next, remove the password from the box and click the OK button.
Read: How to stop or turn off Workbook Sharing in Excel.