drop down lists

S

Sue

I am working with a physician that is keeping track of HIV
patients in an Excel workbook. Can a column be set up so
that it has a drop-down list that will show different
types of immunizations her patients would receive? She is
also wanting to insert the date of the immunization in the
same cell. Is that possible? If so, how do I set this
up? Thanks!
 
D

Dave Peterson

I think the easiest thing to try is Data|Validation.

Debra Dalgleish has tons of tips at:
http://www.contextures.com/xlDataVal01.html

And tell the doc that she would be better off putting that date in an adjacent
cell. It'll make life a lot easier later on if you ever want to do something
with it.

In fact, as a general rule, I find it better to put each field into a separate
column. It's lots easier to combine a couple of cells than to try to separate
it out later.
 
Top