Open the program and select the option of ' Remove Restrictions'. You can remove restrictions from Excel workbook/worksheet by following these steps. We offer 30-day money back guarantee if users have any tech issues with our software. It is 100% secure to use Passper as it is the sub-brand of the highly recognized authorized iMyFone.

Following are some of the features of Passper for Excel software:ġ00% useful to unprotect your Excel sheet and cells. It has amazing features and capabilities to recover the lost or forgotten password. Passper for Excel is one of the most popular and powerful tools to recover the opening password and remove restrictions for MS Excel as it guarantees its users that no data will be deleted from the sheets or the workbooks. Unlock Cells in Excel Even if You’ve Forgotten the Password 2.1 Using Excel Password Recovery Software (100% Work) Using Format Cells option to unprotect certain cells in Excel is much easier than the previous method. Method 2: Unlock Certain Cells via Format Cells Option. Any user with that password can edit the cells. Now, you can choose the cells you specifically want to lock. At this point, your Excel worksheet is protected and specific cells are also unlocked using the password that you inserted. This unlocks all the cells on the worksheet when you protect the worksheet. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. You can also press Ctrl+Shift+F or Ctrl+1. Now, the certain cells that you chose before is unlocked while other cells is locked. On the Home tab, click the Format Cell Font popup launcher. ( There are 3 optional tips to unprotect Excel 2016 worksheet without password in Part 2. Step 4: Confirm the password you entered. Password to Modify: It is set to prevent certain actions on the Excel 2016 sheet including inserting or removing rows, the ability to lock cells, formatting and other changes. You can type in a password to enhance the protection. Step 3: Right click on the sheet name and choose ' Protect Sheet'.

How to protect some cells in excel 2016