When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable certain cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only the specific cells in the desire ranges before you protect the worksheet. You can also specify which users can edit the worksheet.

First, open the worksheet.

1. On the worksheet, select a region in a protected worksheet.

2. On the Review tab, in the Changes group, click Allow Users to Edit Ranges. The Allow Users to Edit Ranges dialogs open.

allow1

3.  Click New button, New Range dialogs open. Type in your password in the Range Password and Confirm new password textbox. Then click the Apply button, and click on OK.

allow2

4.  On the Home tab, in the Font group, click the Format Cell Font dialog box launcher. On the Protection tab, clear the Locked check box, and then click OK.

excel-lock-region

5.  On the Review tab, in the Changes group, click Unprotect Sheet.

allow6

Select the whole worksheet by clicking the Select All button.

allow5

6.  In the Password to unprotect sheet box, type a password for the sheet, click OK, and then retype the password to confirm it.

When you click on any area of the yellow highligted color, the Unclock Range dialog opens. Type in the password to edit the cells.

allow4

When you click on the white area, an information dialog open, telling your that the worksheet is locked.

allow3

 

 
* iOS Development * OS X * Product Review