How to Create a Drop-Down List (Combo Box) in Excel

This video demonstrates how you can make one or multiple drop-down lists, also known as combo boxes, in Excel in a matter of seconds by using data validation and named ranges.

Amazon Affiliate link to Excel 2016 For Dummies (Excel for Dummies)

[craigbest]

Great quick tutorial.  No Microsoft jargon.  To the point.  The "searchlight" feature used at 1:21 is a nice touch too.  Also appreciated the "If you don't have your ribbon up" alternative.  Good job.  Thank you.

[bw]

Great video, helped me out tremendously. Thanks!

[aprilminton]

Excel is the BEST! I'm ridiculously amused by what it can do. :)

[joannaglaze]

how do you create a drop-down lists, with the option to select more than one entry?

[kennethkang]

Hey, good tutorial. I used sheet 1 as primary sheet and sheet 2 for the list of data. So i named list of data for each group and move to sheet1 and did validation drop list. It was working fine and half way through the project, it creates drop list in sheet1, but can't produce the drop list (clicking the arrow drop list won't list the items). So, I recreated in sheet2 and it created drop list without a problem. What are the restrictions when creating the drop list?

[Tequilaboylv]

How do you do a drop-down list and be able to select multiple names? Will I be able to search the drop down and key in multiple names to find? I have Excel for MAC 2011

[AuntMaryLuvsU]

Hi Mike, Can you please teach us to create a drop down list that allows multiple selections?

[jonathanescarcha]

hi can you help me please.. how about if the column you put in animals have a value like dog is 50dollars and i want a drop down list when i choosen a dog it will automatically put the value?

[jwhite]

Can it be done with comboboxes i need the arrows to show.

[franklinhomecillo]

Can anyone help me . I have combo box and text box for data entry. Is there any way when i select item listed on combo box and enter anything on textbox would go to the sheet where i want to put. But combo box will only find the item on the sheet of what was being selected . Only the text box will be entered once selected item found

[enlightenmenttruth]

i want to lock entirely row or column to be lock when i select particular word in list please support

[ladyprintboss]

this video has absolutely nothing to do with a combo box.

[joestraw]

Please edit the verbiage. Make it simple. Takes us to the clicks and done.

[dhawalkpatil]

This is not a combobox. It is just a data validation tool.

[David-huzx]

But, the video is only 3 and a half minutes! XD