Drop down

Your question is unclear. Perhaps you want dependent lists http://www.contextures.com/xlDataVal02.html

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.

It sounds to me as though you would be better off using two dropdowns and using dependent lists. If the items are included in a combo, you will be able to select them.

A technique I use is posted on my website:

(crossposted: http://www.mrexcel.com/forum/showthread.php?t=476123