How do I unprotect an Excel 2007 spreadsheet without the 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 I unprotect an Excel spreadsheet 2007?

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 you unlock a protected Excel file?

You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.

How do I remove encryption from Excel?

Remove password protection from an Excel file To remove password encryption from the file, open the workbook and enter the password in the Password box. Then click File > Info > Protect Workbook > Encrypt with Password. Delete the contents of the Password box, click OK, and then save the file again.

How do you unlock a protected Excel File?

How do I remove protection from an Excel spreadsheet?

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 you unlock an Excel File?

When you want to unlock the sheet, click the File tab on the ribbon menu. Then, click Info, click Protect and click Unprotect Sheet. If there is a password, you will be prompted to enter it.

How can I unlock 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 remove protection from an Excel document?

Open the workbook that you want to change or remove the password for. On the Review tab, click Protect Sheet or Protect Workbook. Click Unprotect Sheet or Protect Workbook and enter the password. Clicking Unprotect Sheet automatically removes the password from the sheet.