How To Create A Drop Down List?

[travelersway]

I Have A List Of Names That I'd Like To Place In One Cell With A Dro
Down Liet. How Would That Be Done?

Thanks For Assistance.
Travelerswa

 

[Bob Phillips]

Data validation will do it. See http://www.contextures.com/xlDataVal01.html

--

HTH

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


"travelersway" <[email protected]>
wrote in message
news:[email protected]...

 

[Paul B]

Have a look here, http://www.contextures.com/xlDataVal01.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"travelersway" <[email protected]>
wrote in message
news:[email protected]...

 

[BenjieLop]

I Have A List Of Names That I'd Like To Place In One Cell With A Dro
Down Liet. How Would That Be Done?

Thanks For Assistance.
Travelersway

Go to

1. Data
2. Validation
3. On the "Allow" box, choose "List"
4. On the "Source" box that will appear, type in the names in your lis
(separated by comma)

Hope this is what you need.

Regards

 

[travelersway]

Thank you all, it works great.
Travelersway