With a password, you can easily protect whatever file you have. Password protection allows you to manage who can approach your files. Nobody else can access the files except the ones you have shared the password with. At times, you may have to edit the data in the workbook and share it with other people using a different password. Or it might be possible that you need to remove password from Excel file. Show
Let’s have a look at how you can quickly remove passwords from Excel files. How to Remove Password Protection in Excel Manually with Info FeatureBelow you will find some useful steps to execute the function:
For Encrypt with Password option, you need to clear the password by clicking OK to remove the password. This step is typically used for Excel versions 2010 to 2019. For Excel 2007 and older versions, you may have to follow the step given below: “Protect Current Sheet” and “Protect Workbook Structure options,” you can have an Unprotect Sheet window and add the password. Click OK the remove the encryption. Remove Password With the Save As OptionBy using this method, you can also remove passwords from Excel files. For this, you need to follow the steps given below:
For Mac Users
Remove Password from the PanelFollow the steps given below:
Remove Protection Password from the Review Tab
That way you can unprotect the sheet and remove the password from the Home tab with the Format option. How to Remove Password from Excel File with the Home Tab
Converting an Excel File into a Zip fileIf the above-mentioned methods are not useful to you and you don’t want to use any third-party software for encrypting an Excel file, you may use this trick easily. Note that this method is not compatible with all the versions of Excel.
Now, you will easily approach the content of the file to view, edit or make changes in the data. How do I remove password protection from Excel workbook?See on the top-left side of the Excel spreadsheet in front of you, click the File tab and choose Passwords from the list. You will see a dialog box File Passwords that shows the password protection to open and edit the excel file. Now, delete the passwords for both text fields and press OK.
How do I remove a password from an Excel 2010 file that is read only?If you want to remove read-only from the Excel document, go to “Save As” > “Tools” > “General Options” and delete the password from the dialog window as well as the checkmark next to “Read-only recommended”.
How can I remove Excel password without password?Just do any of the following:. Right-click the sheet tab, and select Unprotect Sheet… from the context menu.. On the Review tab, in the Changes group, click Unprotect Sheet.. On the Home tab, in the Cells group, click Format, and select Unprotect Sheet from the drop-down menu.. |