Creating Drop Down Lists in Excel 2010

This tutorial will show you how to use the data validation tool to create a drop-down list of options in Microsoft Excel. This tutorial uses Microsoft Excel 2010, but the functionality is available in previous versions as well.

[mikias]

Thank you. This is how tutorials need to be done. Very professional. No junk ads, or self-loathing intros or anything of that nature. Clarity of content, directness, the voice of the o the voice over...so much. Reminds of good old educational videos.

[cristinafernandezcruz]

Exactly what I needed. Brilliant! Easy to follow, well paced. Thank you!

[kimmyd]

Sweet!  very easy to follow.  Much appreciated.  And the trick about using the Fill function is a nice little bonus!!

[abunazih]

Thanks for the demonstration - easy to follow and just what I've been searching for!!

[issatomusakamara]

Thanks very much ....God bless you for this wonderful presentation you have done for the world...I am from Sierra Leone...

[elridgeschwartz]

Brilliant video. Easy, very simple & very helpful.

[nickwalker]

This is a very professionally presented tutorial thank you.

[anjurajk]

Crisp presentation and really helpful 👍🏼

[jessicamarsh]

Very helpful and easy to follow. Thank you!

[vinodbc]

it's really simple and less time consuming trick. superbbb

[pennyjackson]

This was awesome so easy to follow. Thank you.

[voxtimo]

Concise and simple to follow. Thank you!

[AnointedSong]

This was quite helpful. Thank you for clear, concise instructions.

[JARoseman]

Thank you...very simple
You made it seem easy..and it was!
Another tutorial I was viewing...the lady went too fast and was all over the place
Well done!

[Godssoutherndiva]

Thanks this was great and to the point!!!

[madlove]

Thanks so much for this new info since there was another way to do it in excel 2007 

[logicbased]

Great video - extremely easy to follow and quick!

[christopherhall]

Great video,
How do you make each option a different colour

[Banbanjaara]

Thanks v. much, explained in simple way

[mbkongalor]

Great tutorial! Exactly what I needed! Thank you!