How to unlock excel sheet

How do you unlock a locked Excel spreadsheet?

If the worksheet is protected, do the following:
  1. On the Review tab, click Unprotect Sheet (in the Changes group). Click the Protect Sheet button to Unprotect Sheet when a worksheet is protected.
  2. If prompted, enter the password to unprotect the worksheet.

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.

Why is my Excel sheet locked?

If you have locked the file yourself, it might be because the file is open on a different device, or the previous instance of the file didn’t close properly. Tip: Sometimes a file may get locked if everyone editing isn’t using a version that supports co-authoring.

Why can’t I edit Excel sheet?

If you try to use Edit mode and nothing happens, it might be disabled. You can enable or disable Edit mode by changing an Excel option. Click File > Options > Advanced. , click Excel Options, and then click the Advanced category.