Create drop-down menus in Excel

ShowMeAcademy.com - Create drop-down menus in Microsoft Excel 2007

[@paulaz7224]

I have created drop down menus before but I never created a drop down menu in another cell BASED on the value they chose from another cell. Thank you. Your video taught me EXACTLY how to do that. Easy to follow you.

[@sultanabrar5428]

One of the best video's, and the best way of teaching 👍

[@mattolfson9230]

Thank You!! That makes so much more sense than the "Help" instructions in Excel!

[@peravaligiridhar8096]

Explanation was very precise and clear. Thanks Giridhar

[@MrTydriver]

So simple, I watched 5 other videos before I found this one, none really simply answered the question. Thank you !

[@lfieldsjr13]

Thank you! That was so much simpler than any other video.

[@MrPelotero53]

Thanks. Simple and to the point. Nice job !!!

[@mozzrchik]

Thanks. Got right to the point for what I needed. Quick and easy. =)

[@csammy3]

Wow! Awesome tutorial! Short and sweeeet! Thank you!!

[@VanLtheMan]

What do you do if you need select multiple selection from dropdown menu?

[@djdeluxe76]

Thanks for posting that. Works in Excel 2008 on Mac as well.

[@IndigoEyes242]

Extremely helpful, quick and to the point. Thanks!

[@jotapeortiz]

Gracias! Buen video! Corto y explicativo.

[@rikkosbuddy]

Great vid. Short and to the point.

[@tangotech32]

Nice Explanation as compared to other videos on the same topic from Different people. Thanks

[@rockynystrom3035]

Nice and short. Very well done and helpful.

[@nuryusoff4772]

Finally. i found what i need to learn. from the scratch. Thank sir! ^_^

[@thebesttechnical3608]

Supper explanation and very helpful

[@heronbadshah]

I learnd a lot

[@UMAnnie305]

You are a life savers! I was racking my brain to trying to figure out!

[@dechandi]

thanxs man, been looking how to do this for a long time!

[@jofsta]

Proper jedi video - stonking quick tutorial!! Many thanks!

[@pilotjm817]

Fabulous explanation!

[@benjaminkimmich4897]

Thank you!!! You just saved me a hour!

[@255sol9]

Who's still watching this in 2019

[@snowballs442]

thanks that was easy to understand and we were able to understand you when you spoke

[@poonampattanayak2250]

Very simple and helpful. Thank u sir

[@oekiewoekie1]

Exactly what i wantend to know. Also very clear. I Thank you very much for telling me How to do this.

[@armandorodriguez1687]

Thank you... I definitely needed this information for work today

[@arankamarki4244]

Thank you, indeed. A very clear explanation!

[@miriam.mwonge]

Very simple and helpful.

[@keymaster9306]

Thank you so much, very easy and clear

[@actionmechanic]

Waoo Waoo so easy to understood thank you.

[@robertlam3662]

Thank you very much for this helpful guide. It's something I'm able to implement at work. Awesome!

[@zippy_media]

Thanks, very useful and strieght to the point

[@VK-zk1jl]

Thank you. This was helpful !

[@andrewstephens3571]

Thank you very much. Very straight forward

[@OpenhartCreative]

Thank you for this info. I am working on a spreadsheet right now that requires drop down menus! My boss will think I'm brilliant!

[@shubbum]

Thank you, So helpful.

[@ajfam871]

Thank you very helpful and easy to fallow. I have tried others and always seem to miss something.

[@kijjahanmungtham2617]

thank you , cleared and easy to learning .

[@ThatCSIGirl]

Thanks! This was extremely helpful!

[@mtnfmly]

Very nicely described!

[@JamieIsInvesting]

Great job! Thanks very much!

[@abdulrazzaqmahmoodsulaiman9852]

Thank you very much, this was very helpful.

[@jiminberkeley]

Exactly what I needed. Thanks.

[@pradeeprajak45]

Thanks a lot...it helps me alot

[@hairacademy7208]

This was very helpful. Thank you!

[@TheTronalds]

Yeah, just select that column and under the same tab "Data" click Remove Duplicates. It will remove the 2nd Dell entry. There's no need to mess with the Data Validation.

[@DSMStrength]

drop downs are so important we use them all the time for fitness and strength and conditioning programs

[@MrShibataro]

Very well done! Much appreciated.

[@CristianCasapu]

Thank you very much and God bless you.

[@tonwardo974]

Thanks for this tutorial. I learned something new.

[@charlespaul91]

Say you had drop downs for the months in an expense sheet. How would you then automatically add the expenses for an entire month?

[@beverleystewart2791]

This was so easy, thank you

[@Magdoulin]

Ok, but what about the next step? The value or the comment of the selected item from the drop down menu? How to link this with that? How to get sub menu for more options?

[@Theunityandlove]

Thanks very helpful, I don't understand people who dislike this video

[@ericyong88]

very useful video, thanks a lot.

[@misskim2014]

Very useful, thanks!

[@TUBE7777777YOU]

Whoa!!! Awesome lecture.

[@ashutosh676]

Very helpful..... thank you

[@Mdqayyum7]

Thank you so much it was very help full for me..

[@mohanraj-vl1kn]

Thank sir. Today i learned good to know.

[@Feeling_wheeler_lucky]

Thanks you helped me alot

[@istiyaqueahammadbhuiyan5067]

Thank you sir. I have got what in needed.

[@arlenel4017]

I just want to ask, is it possible to delete the text in Column E and what is encoded in the drop-down menus (Column A) remain?

[@bhaveshudesai]

Thanks. It worked for me!!!

[@nonchalant5315]

thanks, this helped me a lot today

[@avrilcrx]

I've found that if you're creating the dropdown list in a macro, use a comma to separate the values. Use the semi-colon if you're adding it directly into the sheet. In case anyone finds that useful.. :)

[@jorev2786]

It's very helpful thank you very much

[@bhagyeshbathani]

Thank you for this video....!! 😊😊

[@15lastone]

Thank you very much, a very helpful lesson

[@mohammedopel]

thank you sir, this was really helpful

[@Just_Hoor09]

Thank u very muchhh, I appreciate it!!!

[@demabegari8183]

Thanks for the great tips

[@30ani38]

Simple and useful!

[@ranamuhammadikhlaq2594]

Can We Lock the folder of dropbox or any file at 2 or 3 places

[@brynnetillman]

This was fantastic - THANKS!

[@jimme1982]

Is it possible to creat a search option in top of the drop down list? If I have a list with 100 different options, it takes a long time to find the correct one if I have to sort through them manually. With a serarch option it would be a lot easier. thx. in advance

[@shifanancy5350]

thank you for this video....very useful one

[@PhaMa1002]

Omg, this was so freakin helpful! Thank you very much!

[@Fresh_MC]

Is there a way to validate the data being dynamically pulled to prevent repeats on your drop down list? Let's say you listed Dell twice, wouldn't it show up twice in your drop down list? Is there a way to test and filter out repeat entries from showing up in the drop down?

[@lephenix1237]

Woow, really awesome 💙

[@Stuntlyd4]

Can it work if I use a filter on the same sheet too (or even the same spreadsheet). As I'm using 2010

[@SamCoreJ]

Just list them in cells somewhere on the spreadsheet and use the button on the source field to select them.

[@pepiluci75]

For some reason by specifying the list separated by commas I obtaing in the drop down menu a unique string 'January, February, March, April, May' and no other options in the drop down. Is there anything I'm doing wrong?

[@afinalhit1987]

Is there anyway that you can create a drop down list by selected specific cells e.g. A1, A3, A5 instead of selecting all the cells?

[@rajeshparmar8255]

Very usful Video...!!!

[@wigindigiyaga2343]

love this!! saving my time to work.

[@natashiatan9494]

What with i wish to add the drop down list after sometimes without affecting other inputs that were inserted earlier?

[@lafishypooh]

Very helpfull thanks very much, I'm using Office 2010 and I works if you put ";" instead of a "," in case anyone is having that problem.

[@supercolourme]

+Cris Parra Marti (Fish) Thanks!

[@charlesstevensontee6101]

Very helpful! Thanks

[@hanzkaran1966]

THANK YOU VERY MUCH!

[@manifestingvlog1504]

Great tutorial!

[@Ringovdheijden]

Thank you for this lesson. But i have a problem. I get no list when i type the list words consecutively with a comma. I use excel 2016, maybe there is a different ?

[@MusicMAAD]

Brilliant. Thank you sir!

[@hjhaddow990]

ok how do we make the dropdown list show data when selected ie if i select dell the other cells show specs or available models for the manufacturer

[@ElUnboxing]

very helpful thank you so much

[@riyazvaziralirozanisalima6541]

thanks i got it what i needed

[@alihaleem2705]

great video thanks