How do you create a selection box for data entry within excel

[Guest]

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?

 

[Daniel CHEN]

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

(e-mail address removed)
www.Geocities.com/UDQServices

Free Data Processing Add-in<

===== * ===== * ===== * =====