Dropdown

**Manvinder8** · 06-22-2010, 12:20 AM

Hi I need list of drop down menu that will contain categories of different lists. for example
Fruit
Banana
Apple
Pear
Vegetable
Potato
Peas
I need this sort of drop down list, but they cannot select fruit or Vegetable, but they can select Banana , apple, pear , potato or peas.

**royUK** · 06-22-2010, 12:32 AM

You aren't getting answers because your questions are too vague

**Manvinder8** · 06-22-2010, 12:39 AM

I have tried to explain my question

**pike** · 06-22-2010, 01:31 AM

Hi Manvinder8
you will need to do it with named ranges
eg.....

**Manvinder8** · 06-22-2010, 01:45 AM

Hi Pike I do not need two dropdown list ..
I just need one dropdown list with named categories like fruit and vegetables because I have hundred of values in drop down list. It is better to have categories. But I need people cannot select fruit or vegetable means categiry name in drop down list ..
Thanks'

**teylyn** · 06-22-2010, 01:47 AM

Manvinder, for your next question, please select an appropriate question forum before you click the New Thread button. The feedback forum is for feedback on the site, not for Excel questions.

Thanks

moved to Excel General

**pike** · 06-22-2010, 02:09 AM

Hi Manvinder8,
No can do.. you'll need the two

**Manvinder8** · 06-22-2010, 07:02 PM

thanks but I do not need depended lists. I need just one drop down list..
for example drop down list show following options..
Fruit
Banana
Apple
Pear
Vegetable
Potato
Peas
People may select each option except Fruit and Vegetable.
I have hundred of names in drop down list. I want to categories that list to different list in one drop down (as above fruit and vegetable); so that it'll be easier for people to find through drop down.
I have tried to explain more. May be I have confused more.