help
 

how do i make a drop list with multiple entries in excel. i am in a calendar
format trying to make a drop down lit with multiple entries such as:
tardy, off, sick, etc.
its a calendar for each employee to go in a request off of whatever

help
 

DataValidation, select a type of List, and then just type the values comma
separated.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"matrix" wrote in message
...
how do i make a drop list with multiple entries in excel. i am in a
calendar
format trying to make a drop down lit with multiple entries such as:
tardy, off, sick, etc.
its a calendar for each employee to go in a request off of whatever