How do I unprotect an Excel worksheet if I forgot the password?

How do I unprotect an Excel worksheet if I forgot 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 unprotect a workbook in Excel 2013?

Unprotect an Excel worksheet

  1. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
  2. If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box, and click OK.

How do I unlock a password protected Excel 2013 file?

How to unprotect a password protected worksheet.

  1. Step 1 Press ALT + F11 or click View Code on the Developers Tab.
  2. Step 2 Double click on the worksheet that is password protected.
  3. Step 3 Copy and paste the code below into the (Code) window.
  4. Step 4 Click on the Run Button or press F5.

How do I lock a workbook in Excel?

Protect an Excel file

  1. Select File > Info.
  2. Select the Protect Workbook box and choose Encrypt with Password.
  3. Enter a password in the Password box, and then select OK.
  4. Confirm the password in the Reenter Password box, and then select OK.

How do I unlock a protected Excel sheet for free?

Step 1: Open the worksheet you want to unprotect. Step 2: Click on File > Info > Unprotect Sheet. Step 3: Or go to Review Tab > Changes > Unprotect Sheet. Step 4: If the worksheet asked the password for opening, enter the password and click.

How do I password protect an Excel 2013 File?

How do I protect an Excel workbook with password?

Require a password to open or modify a workbook

  1. Open the sheet or workbook that you want to protect.
  2. On the Review tab, click Protect Sheet or Protect Workbook.
  3. In the Password box, type a password, and in the Verify box, type the password again.
  4. Choose any other protection options you want and click OK.
  5. Click Save.

How do I unlock a protected Excel spreadsheet?

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

To unprotect a sheet, follow these steps:

  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 restrict access to an Excel spreadsheet?

  1. Go to File > Info > Protect Document/Workbook/Presentation > Restrict Permission by People > Restricted Access. The Permission window will open.
  2. Make sure the Restrict Permission to this document box is selected. Enter the email addresses of individuals who can Read or Change the document. Click ok.

How do you unlock protected Excel sheet without password?

1. Download Office Password Remover, install and launch it. 2. Click Open button and select the Excel (.xls) file which you want to unlock. 3. Click Remove Password button, the protected password will be removed from your Excel workbook in a soon. 4. Click on Open, you will find the Excel file is unlocked without password.

How do I unlock an Excel spreadsheet with password?

To unlock Excel cells, go to the Review tab and click Unprotect sheet. If the author of the sheet has added a password to protect it, you will need to enter the password in order to unlock the cells. If there’s no password, you will be able to edit the locked cells after clicking the unprotect sheet button.

How can I recover lost Excel worksheet password?

Part 2: How to Recover Excel Workbook Password If Forgotten Download a Copy of Excel Password Recovery. Please download Excel Password Recovery hosted on this website and install the program afterwards. Add Encrypted Excel File to the Program. From the main screen, click the first option labelled “Recovery Open Password from Excel “. Select Password Recovery Type. Start Recovering Password from Excel Workbook.

How do I unlock a locked Excel sheet?

Open the Excel workbook you want to unlock. Select “Tools,” “Protection” and “Unlock Workbook” from the toolbar. If you added a password initially (when you locked the file), you will be prompted to type it in. Click on “OK” in the “Unprotect Workbook” box.