Is there a way for me to lock only one cell in Exel 2003? Thanks!

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



AJB wrote:

Is there a way for me to lock only one cell in Exel 2003? Thanks!

--

Dave Peterson

Hi,

By default all the cell are locked in the Worksheet.

To lock only one cell, follow this procedu

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

"AJB" wrote:

Is there a way for me to lock only one cell in Exel 2003? Thanks!