locking only one cell

D

Dave Peterson

Unlock all the other cells.
Lock the cell you want locked.
(use format|cells|protection tab for these)

Then protect the worksheet.
tools|protection|protect sheet
 
G

Guest

Hi,

By default all the cell are locked in the Worksheet.

To lock only one cell, follow this procedure:

1. Press CTRL+A, to select a whole worksheet.
2. On the Format menu, click Cells. The Format Cells dialog appears.
3. Click the Protection tab, and clear the Locked check box.
4. Click OK to return to the Worksheet.
5. Click the cell you want to lock.
6. On the Format menu, click Cells. The Format Cells dialog appears.
7. Click the Protection tab, and select the Locked check box.
8. Click OK to return to the Worksheet.
9. On the Tools menu, point to Protection and then click Protect Sheet.
10. In the Protect Sheet dialog box, select Protect Worksheet and Contents
of Locked Cell. This will only protect that worksheet in the workbook.
11. Enter a passowrd in the "Password to Unprotect Sheet".
12. In the "Allow all users of the worksheet to" list select the "Select the
Locked Cell" check box.
13. Click Ok. The Confirm Password dialog box appears.
14. Enter the password in the "Reenter the password to proceed" the text box.
15. Click OK to return to the Worksheet.
16. On the File menu, click Save As.
17. In the File name text box enter a name, and click the Save button.

Challa Prabhu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top