ShowMeAcademy.com - Create drop-down menus in Microsoft Excel 2007
Пікірлер: 212
@paulaz72248 жыл бұрын
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.
@sultanabrar54283 жыл бұрын
One of the best video's, and the best way of teaching 👍
@mattolfson923010 жыл бұрын
Thank You!! That makes so much more sense than the "Help" instructions in Excel!
@peravaligiridhar80964 жыл бұрын
Explanation was very precise and clear. Thanks Giridhar
@MrTydriver7 жыл бұрын
So simple, I watched 5 other videos before I found this one, none really simply answered the question. Thank you !
@lfieldsjr1310 жыл бұрын
Thank you! That was so much simpler than any other video.
@MrPelotero5313 жыл бұрын
Thanks. Simple and to the point. Nice job !!!
@mozzrchik12 жыл бұрын
Thanks. Got right to the point for what I needed. Quick and easy. =)
@csammy310 жыл бұрын
Wow! Awesome tutorial! Short and sweeeet! Thank you!!
@VanLtheMan15 жыл бұрын
What do you do if you need select multiple selection from dropdown menu?
@djdeluxe7616 жыл бұрын
Thanks for posting that. Works in Excel 2008 on Mac as well.
@IndigoEyes2427 жыл бұрын
Extremely helpful, quick and to the point. Thanks!
@jotapeortiz4 жыл бұрын
Gracias! Buen video! Corto y explicativo.
@rikkosbuddy12 жыл бұрын
Great vid. Short and to the point.
@tangotech3214 жыл бұрын
Nice Explanation as compared to other videos on the same topic from Different people. Thanks
@rockynystrom303510 жыл бұрын
Nice and short. Very well done and helpful.
@nuryusoff47728 жыл бұрын
Finally. i found what i need to learn. from the scratch. Thank sir! ^_^
@thebesttechnical36084 жыл бұрын
Supper explanation and very helpful
@heronbadshah4 жыл бұрын
I learnd a lot
@UMAnnie30512 жыл бұрын
You are a life savers! I was racking my brain to trying to figure out!
@dechandi16 жыл бұрын
thanxs man, been looking how to do this for a long time!
@jofsta12 жыл бұрын
Proper jedi video - stonking quick tutorial!! Many thanks!
@pilotjm8174 жыл бұрын
Fabulous explanation!
@benjaminkimmich48976 жыл бұрын
Thank you!!! You just saved me a hour!
@255sol95 жыл бұрын
Who's still watching this in 2019
@snowballs4429 жыл бұрын
thanks that was easy to understand and we were able to understand you when you spoke
@poonampattanayak22505 жыл бұрын
Very simple and helpful. Thank u sir
@oekiewoekie16 жыл бұрын
Exactly what i wantend to know. Also very clear. I Thank you very much for telling me How to do this.
@armandorodriguez16876 жыл бұрын
Thank you... I definitely needed this information for work today
@arankamarki42444 жыл бұрын
Thank you, indeed. A very clear explanation!
@miriam.mwonge9 жыл бұрын
Very simple and helpful.
@keymaster93066 жыл бұрын
Thank you so much, very easy and clear
@actionmechanic5 жыл бұрын
Waoo Waoo so easy to understood thank you.
@robertlam36629 жыл бұрын
Thank you very much for this helpful guide. It's something I'm able to implement at work. Awesome!
@zippy_media9 жыл бұрын
Thanks, very useful and strieght to the point
@VK-zk1jl4 жыл бұрын
Thank you. This was helpful !
@andrewstephens35719 жыл бұрын
Thank you very much. Very straight forward
@OpenhartCreative11 жыл бұрын
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!
@shubbum3 жыл бұрын
Thank you, So helpful.
@ajfam87110 жыл бұрын
Thank you very helpful and easy to fallow. I have tried others and always seem to miss something.
@kijjahanmungtham26177 жыл бұрын
thank you , cleared and easy to learning .
@ThatCSIGirl10 жыл бұрын
Thanks! This was extremely helpful!
@mtnfmly13 жыл бұрын
Very nicely described!
@JamieIsInvesting3 жыл бұрын
Great job! Thanks very much!
@abdulrazzaqmahmoodsulaiman98526 жыл бұрын
Thank you very much, this was very helpful.
@jiminberkeley13 жыл бұрын
Exactly what I needed. Thanks.
@pradeeprajak454 жыл бұрын
Thanks a lot...it helps me alot
@hairacademy72085 жыл бұрын
This was very helpful. Thank you!
@TheTronalds11 жыл бұрын
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.
@DSMStrength7 жыл бұрын
drop downs are so important we use them all the time for fitness and strength and conditioning programs
@MrShibataro12 жыл бұрын
Very well done! Much appreciated.
@CristianCasapu12 жыл бұрын
Thank you very much and God bless you.
@tonwardo9748 жыл бұрын
Thanks for this tutorial. I learned something new.
@charlespaul915 жыл бұрын
Say you had drop downs for the months in an expense sheet. How would you then automatically add the expenses for an entire month?
@beverleystewart27915 жыл бұрын
This was so easy, thank you
@Magdoulin10 жыл бұрын
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?
@Theunityandlove11 жыл бұрын
Thanks very helpful, I don't understand people who dislike this video
@ericyong888 жыл бұрын
very useful video, thanks a lot.
@misskim20144 жыл бұрын
Very useful, thanks!
@TUBE7777777YOU11 жыл бұрын
Whoa!!! Awesome lecture.
@ashutosh6765 жыл бұрын
Very helpful..... thank you
@Mdqayyum78 жыл бұрын
Thank you so much it was very help full for me..
@mohanraj-vl1kn7 жыл бұрын
Thank sir. Today i learned good to know.
@Feeling_wheeler_lucky4 жыл бұрын
Thanks you helped me alot
@istiyaqueahammadbhuiyan50678 жыл бұрын
Thank you sir. I have got what in needed.
@arlenel401710 жыл бұрын
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?
@bhaveshudesai10 жыл бұрын
Thanks. It worked for me!!!
@nonchalant53157 жыл бұрын
thanks, this helped me a lot today
@avrilcrx8 жыл бұрын
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.. :)
@jorev27865 жыл бұрын
It's very helpful thank you very much
@bhagyeshbathani7 жыл бұрын
Thank you for this video....!! 😊😊
@15lastone7 жыл бұрын
Thank you very much, a very helpful lesson
@mohammedopel12 жыл бұрын
thank you sir, this was really helpful
@Just_Hoor094 жыл бұрын
Thank u very muchhh, I appreciate it!!!
@demabegari81836 жыл бұрын
Thanks for the great tips
@30ani389 жыл бұрын
Simple and useful!
@ranamuhammadikhlaq25945 жыл бұрын
Can We Lock the folder of dropbox or any file at 2 or 3 places
@brynnetillman13 жыл бұрын
This was fantastic - THANKS!
@jimme198215 жыл бұрын
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
@shifanancy53509 жыл бұрын
thank you for this video....very useful one
@PhaMa10025 жыл бұрын
Omg, this was so freakin helpful! Thank you very much!
@Fresh_MC11 жыл бұрын
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?
@lephenix12375 жыл бұрын
Woow, really awesome 💙
@Stuntlyd410 жыл бұрын
Can it work if I use a filter on the same sheet too (or even the same spreadsheet). As I'm using 2010
@SamCoreJ12 жыл бұрын
Just list them in cells somewhere on the spreadsheet and use the button on the source field to select them.
@pepiluci7514 жыл бұрын
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?
@afinalhit19879 жыл бұрын
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?
@rajeshparmar82559 жыл бұрын
Very usful Video...!!!
@wigindigiyaga234312 жыл бұрын
love this!! saving my time to work.
@natashiatan949410 жыл бұрын
What with i wish to add the drop down list after sometimes without affecting other inputs that were inserted earlier?
@lafishypooh9 жыл бұрын
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.
@supercolourme8 жыл бұрын
+Cris Parra Marti (Fish) Thanks!
@charlesstevensontee610110 жыл бұрын
Very helpful! Thanks
@hanzkaran19663 жыл бұрын
THANK YOU VERY MUCH!
@manifestingvlog15048 жыл бұрын
Great tutorial!
@Ringovdheijden5 жыл бұрын
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 ?
@MusicMAAD7 жыл бұрын
Brilliant. Thank you sir!
@hjhaddow99012 жыл бұрын
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