How do I remove a password from an Excel 2010 workbook?
Remove a workbook password
- Open the workbook that you want to remove the password from.
- On the Review tab, under Protection, click Passwords.
- Select all contents in the Password to open box or the Password to modify box, and then press DELETE.
- Click Save .
How do I unprotect an Excel 2010 worksheet without the password?
How to unprotect Excel sheet
- 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.
How do I remove a password from a reserved Excel file?
Still have issues removing “reserved by”….With the file open, you can re-save it without the password, as follows:
- Click on “Save-As” from the file menu.
- From the tools menu in the “Save As” window, choose”General Options”.
- Remove the password to modify.
How do you unlock a password protected Excel workbook?
Unprotect an Excel worksheet
- Go to the worksheet you want to unprotect.
- Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
- If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box, and click OK.
How do I open an Excel spreadsheet without the password?
Re: How to unprotect the excel sheet if forgot the password
- Open your Excel document and switch to the password-protected sheet.
- Press Alt + F11 to open the Visual Basic Editor.
- Right-click the workbook name on the left pane (Project-VBAProject pane) and select Insert > Module from the context menu.
How do I unlock a protected Excel file?
How to Unlock an Excel Workbook as the Owner
- Open the protected spreadsheet, and select Review > Unprotect Sheet.
- Enter the password used to protect the spreadsheet, then select OK.
- Your spreadsheet will now be unprotected and it can be modified.
How do you edit a restricted Excel file?
Remove editing restrictions: To remove editing restrictions, click Stop Protection at the bottom of the Restrict Editing pane. Remove or change restricted access: To remove or change restricted access, open the file, and then click Change Permission in the yellow bar at the top of the document.
How do I make my Excel spreadsheet read-only without password?
Click on the Tools button and click General Options. 5. In the Password to modify box, enter a password and click OK. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don’t enter a password and check Read-only recommended.
How can I open an Excel file if I forgot the password for free?
Open a password protected excel file without password
- Download Office Password Remover, install and launch it.
- Click Open button and select the Excel (.
- Click Remove Password button, the protected password will be removed from your Excel workbook in a soon.