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

L

Ligia Magnus

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?
 
D

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

[email protected]
www.Geocities.com/UDQServices
Free Data Processing Add-in<
Click to expand...
===== * ===== * ===== * =====
 
Top