Passwords

Hi Rekha

As a default all cells in the worksheet are locked when you password protect the worksheet.

But you can unlock some cells so that when the worksheet is protected users can enter data in those cells. To do this:

1. Highlight the cells to be unlocked.

2. Select Format menu and click cells.

3. Click the Protection tab.

4. Untick the Locked tick box.

5. Click OK.

Then password protect the worksheet as seen below:

1. Select Tools Click Protection.

2. Click Protect Sheet.

3. Enter the password to unprotect sheet. Click OK.

4. Re-enter the password to confirm and click OK.

The sheet is password protected although you can enter data in the unlocked cells

Hope this helps

Carlos