How do you unlock an Excel 2010 spreadsheet without the password?

Solution 1: Unprotect Excel 2010 File without Password using VBA Code

Open your Excel file and press Alt + F11 to open the Microsoft Visual Basic for Applications.
Now Right click on the workbook name and select Insert > Module.
A dialogue box will appear in the right pane.
Now click on Run button to execute code.

How do you unlock an Excel spreadsheet without the password?

If your sheet is a password-protected worksheet, Excel will prompt you to enter the password. Type the password in the Unprotect Sheet dialog box and click ‘OK’. If your worksheet was not protected with a password, clicking the ‘Unprotect Sheet’ option is enough to unlock your sheet.

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

Unprotect an Excel worksheet

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

How do I remove encryption from Excel?

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 change a password in Excel 2010?

Option 1: Change Known Excel 2010 Password

Open the document and get full access by entering password.
Now navigate to File > Info >Protect Document > Encrypt with Password.
Now clear the dialogue box and type-in the new password.
A new dialogue box will ask you to confirm password.

How do you unlock a locked Excel File?

On the Home tab, click the Format Cell Font popup launcher. 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 can I recover my Excel password?

To open a password protected Excel file, there is a simple method that works in 90% of cases.

Create a Gmail account.
Log into your Gmail account.
Click on Documents.
Click on Upload.
Google Docs automatically allows you to make changes.
Save the File with a different name.
Download the new File as an Excel File.

How do I unprotect an Excel sheet?

Follow below steps to unprotect excel sheet. Step 1: Go to Review tab & click on Unprotect Sheet. Step 2: As soon as you click on Unprotect it will ask you to enter the same password which you have typed while protecting the sheet. Step 3: After the password is entered click on OK.

How do I unlock a locked Excel spreadsheet?

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. The workbook will be unlocked.

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 we can protect sheet in Excel?

Open the spreadsheet you want to protect in Excel, click the “Review” tab and then click “Protect Sheet” in the Changes group to display the Protect Sheet dialog. The “Protect worksheet and contents of locked cells” option is enabled by default; enable it if it’s not.