| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock one single cell on a worksheet using Excel 2003.
I have tried to follow the instructions for locking a single cell, however, I
am unsuccessful. The instructions are from the Microsoft Online help. If someone has been successful with this task please let me know. I am anxious to figure this out. -- Appreciate any tips. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock one single cell on a worksheet using Excel 2003.
1. Unlock all cells
2. Lock the selected cell 3. Protect the worksheet -- Gary''s Student - gsnu200758 "Sally" wrote: I have tried to follow the instructions for locking a single cell, however, I am unsuccessful. The instructions are from the Microsoft Online help. If someone has been successful with this task please let me know. I am anxious to figure this out. -- Appreciate any tips. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock one single cell on a worksheet using Excel 2003.
Without protect of sheet:
Data/Validate/Personnal =Len(A1)=0 JB http://boisgontierjacques.free.fr/ On 24 nov, 04:07, Sally wrote: I have tried to follow the instructions for locking a single cell, however, I am unsuccessful. The instructions are from the Microsoft Online help. If someone has been successful with this task please let me know. I am anxious to figure this out. -- Appreciate any tips. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I adjust column width of a single cell within Excel 2003? | Excel Discussion (Misc queries) | |||
| Save a single worksheet in Excel as a single file. | New Users to Excel | |||
| Can a single cell be protected in Excel 2003? | Excel Worksheet Functions | |||
| How do I lock a formula in a cell in an Excel worksheet? | Excel Discussion (Misc queries) | |||
| How do I lock a formula in a cell in an Excel worksheet? | Excel Worksheet Functions | |||
Linear Mode
