How do I remove a password from an Excel 2010 workbook?

Remove a workbook password

  1. Open the workbook that you want to remove the password from.
  2. On the Review tab, under Protection, click Passwords.
  3. Select all contents in the Password to open box or the Password to modify box, and then press DELETE.
  4. Click Save .

How do I unprotect an Excel 2010 worksheet without the password?

How to unprotect Excel sheet

  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 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:

  1. Click on “Save-As” from the file menu.
  2. From the tools menu in the “Save As” window, choose”General Options”.
  3. Remove the password to modify.

How do you unlock a password protected Excel workbook?

Unprotect an Excel worksheet

  1. Go to the worksheet you want to unprotect.
  2. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
  3. 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

  1. Open your Excel document and switch to the password-protected sheet.
  2. Press Alt + F11 to open the Visual Basic Editor.
  3. 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

  1. Open the protected spreadsheet, and select Review > Unprotect Sheet.
  2. Enter the password used to protect the spreadsheet, then select OK.
  3. 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

  1. Download Office Password Remover, install and launch it.
  2. Click Open button and select the Excel (.
  3. Click Remove Password button, the protected password will be removed from your Excel workbook in a soon.
Categories: Other