Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How To Create A Drop Down List?
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 |
#2
|
|||
|
|||
Data validation will do it. See http://www.contextures.com/xlDataVal01.html
-- HTH RP (remove nothere from the email address if mailing direct) "travelersway" wrote in message news:travelersway.1tijje_1123618020.3752@excelforu m-nospam.com... 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 |
#3
|
|||
|
|||
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" wrote in message news:travelersway.1tijje_1123618020.3752@excelforu m-nospam.com... 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 |
#4
|
|||
|
|||
travelersway Wrote: 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. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=394336 |
#5
|
|||
|
|||
Thank you all, it works great. Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=394336 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create drop down for address list | Excel Discussion (Misc queries) | |||
drop down list | Excel Worksheet Functions | |||
How do I create a drop down list in Excel 2003 | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) |