MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pulldown list for names


Posted by TC on January 11, 2002 6:09 AM

I haven't used excel in over 5 years, so my skills are slightly tarnished. Help!
can anyone give me a quick tip on how to create a pulldown list with a variety of names?


Posted by Michael on January 11, 2002 6:26 AM

There are a couple of ways to do this. By far the easiest is to click the cell that you want the list to appear in. Go to:
Data
Validation
On the settings sheet under Allow ->select List
A small button and window will appear labeled Source: (you can either type the list in manually seperated by commas with no spaces(ie word,word)or you can select a range of cells containing the information that you want to show (ie =A1:BA1 or =A1:A100): Good Luck.

Posted by TC on January 11, 2002 6:34 AM

Hey Mike...thanks alot for the help. That was way to simple.

Posted by Andy gee on January 11, 2002 6:54 AM

You can also make the list dynamic by using OFFSET in the validation list box!

Posted by Jo on January 11, 2002 7:12 AM

: I haven't used excel in over 5 years, so my skills are slightly tarnished. Help! : can anyone give me a quick tip on how to create a pulldown list with a variety of names? You can also make the list dynamic by using OFFSET in the validation list box!

Can you explain more about OFFSET to me? (Still learning Excel, sorry).

Posted by Andy Gee on January 11, 2002 7:38 AM

Check your email!