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 Drop Down Liet. How Would That Be Done?

Thanks For Assistance.
Travelersway

[BenjieLop]

I Have A List Of Names That I'd Like To Place In One Cell With A Drop 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 list (separated by comma)

Hope this is what you need.

Regards.

[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]...
>
> I Have A List Of Names That I'd Like To Place In One Cell With A Drop
> Down Liet. How Would That Be Done?
>
> Thanks For Assistance.
> Travelersway
>
>
> --
> travelersway
> ------------------------------------------------------------------------
> travelersway's Profile:
http://www.excelforum.com/member.php...o&userid=17623
> View this thread: http://www.excelforum.com/showthread...hreadid=394336
>

[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]...
>
> I Have A List Of Names That I'd Like To Place In One Cell With A Drop
> Down Liet. How Would That Be Done?
>
> Thanks For Assistance.
> Travelersway
>
>
> --
> travelersway
> ------------------------------------------------------------------------
> travelersway's Profile:
> http://www.excelforum.com/member.php...o&userid=17623
> View this thread: http://www.excelforum.com/showthread...hreadid=394336
>

[travelersway]

Thank you all, it works great.
Travelersway