I am trying to setup an excel form for data entry and I'd like to have the
entry clerk select from a list of items for one of the columns. For example
- THe column name is Status - I'd like them to be able to select Single,
Married, Divorced, Separate.

How can I setup the spreadsheet to accept this type of data entry?

1) First type Single, Married, Divorced, Separate in any range where you
entry clerk can not modify it, say M1:M4.
2) Select the Status column
3) Tools Data Validation
4) Setting: Allow - "list", Source - "M1:M4", Check "Ignore blank" and "In
Cell drop Down"

===== * ===== * ===== * =====
Daniel CHEN


www.Geocities.com/UDQServices
Free Data Processing Add-in<
===== * ===== * ===== * =====

"Ligia Magnus" <Ligia wrote in message
...
I am trying to setup an excel form for data entry and I'd like to have the
entry clerk select from a list of items for one of the columns. For
example
- THe column name is Status - I'd like them to be able to select Single,
Married, Divorced, Separate.

How can I setup the spreadsheet to accept this type of data entry?