Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to protet a cell
I would like to know if there is a way with excel 2003 to protect a cell and
the type the answer in that cell? Example: Name______________________ and to be able to type your name in the line. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to protet a cell
In order to do this you would need to validate the names because Excel has no
way of knowing if John Smith or sfnksdfk is a name. To do this create a list of accpetable names and then select your input cell and click data - validation - select list and then input the range of your list (A1:A100 for example). users will then only be able to selct names from the validated list. Mike "Scottyvan" wrote: I would like to know if there is a way with excel 2003 to protect a cell and the type the answer in that cell? Example: Name______________________ and to be able to type your name in the line. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |