how to protet a cell

S

Scottyvan

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.
 
M

Mike

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
 
Top