How Do I Unprotect An Excel Worksheet?

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.

Contents

How do I unprotect an Excel worksheet if I forgot 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 remove protection from an Excel workbook?

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.

How do you unlock a protected 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 I unlock a password protected Excel file?

The steps are pretty simple. All you have to do is open the desired workbook and click on the Unprotect Sheet, which will remove the password. To change the password, click on Protect Workbook and type and confirm the new password.

How do you unprotect a worksheet if you forgot the password?

Just follow any of these steps: Open the protected spreadsheet, and switch to the ‘Review’ tab and click the ‘Unprotect Sheet’ icon in the Changes group. You can access the same above option by right-clicking the protected spreadsheet tab, then select the ‘Unprotect Sheet’ option from the context menu.

How do I unlock a protected Excel spreadsheet?

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 I unprotect an 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 you remove protection from an Excel workbook?

Follow these steps:

  1. Click F12.
  2. Just to the left of the Save button, click Tools.
  3. Click General Options.
  4. Delete any password evident in the Password to Open box.
  5. Delete any password evident in the Password to Modify box.
  6. Clear the Read-Only Recommended check box.
  7. Click on OK.
  8. Click Save.

How do I unprotect an Excel workbook without the password?

How to Remove Password from Excel Spreadsheet (Unprotect Excel)

  1. Step 1: Go to Control panel.
  2. Step 2: Click on Folder Options.
  3. Step 3: Open View Tab.
  4. Step 4: Uncheck “Hide Extension for the known file type”
  5. Step 5: Select the excel file.
  6. Step 6: Change the extension of your Excel file from .
  7. Step 7: Open Zip File & Extract.

How do I unprotect an Excel worksheet without the password?

Unprotect Excel Worksheet with password

  1. Open the Excel file. (If have encrypted the Excel file with password and forgot the opening password, go to Part 1.)
  2. Click on Review, select Unprotect Sheet.
  3. Enter the Unprotect Sheet password, and click on Ok. And then you can edit the data on this Excel Sheet again.

How do I unprotect an Excel sheet?

How to unprotect a cell or worksheet

  1. In the menu bar, click the Review tab.
  2. In the Protect group, click the Unprotect Sheet option.
  3. In the Unprotect Sheet sheet window that pops up, enter the password to unlock the worksheet, then click OK.

How do you remove protection from an Excel spreadsheet?

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 open an Excel file if I forgot the password?

How to Open a Password Protected Excel File if Forgot Password

  1. However, if you are unfortunate to forget your Excel file protected password, how to open 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.

How do you unlock an Excel spreadsheet if you 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 remove password 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 I unlock a protected Excel sheet for free?

Unprotect Excel from any device: Windows, Mac, Linux, Android and iOS.

  1. Upload your Excel files to unlock.
  2. Enter the protection password.
  3. Press the “UNLOCK” button.
  4. Download the unlocked files instantly or send a download link to email.

How do I remove password protection in Excel without password?

How to unprotect a password protected worksheet.

  1. Step 1 Press ALT + F11 or click View Code on the Developer 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 unprotect a sheet in Excel?

Whenever we want to unprotect sheet, we can:

  1. Right-click on the worksheet tab and select the “unprotect button.” We can also go to the review tab and select unprotect sheet.
  2. Next, we will go to the home tab, select “Cells” group and click Format. Next, we will pick “Select Unprotect sheet”

How do I remove a password protection from Excel?

  1. Launch the Excel program and open the worksheet. You need to remove the password.
  2. On the main ribbon menu, go to the Home tab.
  3. Under the Cells group, click Format’s drop-down arrow. From the list, select Unprotect Sheet.
  4. Type in the password and then click OK to remove the password.

How do I turn off Protected View in Excel?

Click File > Options. Click Trust Center > Trust Center Settings > Protected View. Disable the Enable Protected View for files originating from the internet checkbox.