Excel Drop Down List Tutorial

[@KevinStratvert]

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@guytaylor8496]

How can I create drop down for choosing a date?

[@KevinStratvert]

@@guytaylor8496 unfortunately you can't do it out of the box. There are third party plug ins that give you that capability.

[@ErisvaldoJunior]

Didn't work automatic input for new value

[@waqasarshad7904]

@KevinStratvert I am working to create an excel sheet for a specific purpose mainly covering some business details for me. Your video's topic may also be helpful for me, but I have another query. Can you please help me out? I have hardly found anything close so far. For some entries in cells, I have used data validation (selected 'List' as validation criteria under 'Allow' tab of Data Validation window) for three options. In addition to that, I have used Conditional Formatting, made a New Rule by selecting 'Use a formula to determine which cells to format' and used 'Format' button to fill the colors of cells. The purpose is to identify the cells based on outcome and color of the formatted cell (e.g. Excellent, Good, Poor as three options in drop-down of a single cell). For the purpose of sharing the information to other, I want to add the comments with each of the drop-down option. Is there a way that can be helpful to auto-populate separate comment based on drop-down selection of data validation options of a single cell?

[@Elcxy.1010]

Thank you for the tutorial im in school idk anything about excel

[@mdfenn]

Basically my boss thinks I’m like really talented. Nope I just pull up these videos ever time I need to do something new in excel. Thanks man!

[@veronica9896]

Same here. 😊 Kevin, you are a real life/work saver 💯♥️

[@marnonjaetolentino1825]

thats why im here

[@Hjonvard]

Great tutorial. No fluff, no annoying music, crystal clear speaking. You need to make a tutorial on making tutorials

[@japanboy31415]

lol what do u mean ? there was so much fluff

[@barryeady2239]

Great job explaining the drop down list. How can you use the drop down list to bring in additional columns from the list. Example: The drop down list contain various fruits. When you select a fruit, the related unit price of that fruit also populates the table. Then, you can enter the quantity and use a formula to get the extended price. Similar to an invoice.

[@Melpy253]

I typed in a really long "search" request, not knowing how to explain what I wanted to do. Your video was exactly what I was looking for!! Thank you for creating such clear and easy to follow instructions!!

[@stanleyrunyon]

I saw this just now. Things have changed. I seem to remember when you couldn't create a dropdown list from referencing a Table directly. It's much easier now. Thanks for this tutorial.

[@harshenvy]

It first didn’t workout for me until I realised that some excel versions require a semicolon (;) instead of a comma (,) when writing 3:15. It’s a small difference that had me buzzing for like 5 minutes. Hope others avoid this mistake

[@andriisavchyn2977]

ms as always... they are just making useless changes in updates and confuses people... your comment helped a lot:)

[@Discretion_seems_to_be_fading.]

I suuuper appreciate when I need an answer and I get EXACTLY what I needed without all the fluff. So much so, that I'm actually leaving this comment and thumbs upping your vid. Thanks.

[@thecatlady-n3n]

It's taken me a while but I got there in the end. You have to be careful to do the steps in order otherwise it all goes pear shaped. I do believe I've learned a new skill. Thanks Kevin.

[@bettyc931]

I have been trying to find this by reading or other videos online. You gave the clearest explanation. Thank you!!

[@wangag2663]

Honestly i thought it was more complicated than this!!! I've always avoided working with excel (or doing stuff manually with no formulas etc) coz some instructions or videos are so vague or poorly made respectively. Ill be checking out later "pivot tables" if you have a video on that. I am sooo subcribing to learn more tricks. PS: This is the longest comment i've ever made on YT.

[@chidubemnnabugwu2625]

😅

[@jasonchristopherson5243]

Excellent Tutorial Kevin, saved me a lot of time and headaches! The only issue that I am having is when I add additional content to the tables they are not showing in the drop downs even though they are showing as part of the table, the data validation is limiting to my original table. I am and absolute novice so if anyone reads this and knows what I am doing wrong I would greatly appreciate a hand!

[@justnandesigns]

Excellent concise presentation and explanation of drop down lists. Good job Kevin!

[@growqueen]

OMG you are the best. This is exactly what I needed. My boss asked me to do this and I had no idea.

[@adolor6570]

Thanks Kevin. I like how you get straight to the point. No long winded videos.

[@Thrive2024]

Thank you so much sir Kevin, actually my teacher assigned us an assignment regarding this kind of scenario where we are needed to think a solution on how can we immediately have a list of items so we can easily input it on a cell. Fortunately I have found this video of you, You save me😢😊❤🎉 Thank you so much once again.🎉

[@IlluminatingThoughtTv]

This tutorial is awesome! I learned more from this tutorial than I did in a semester in college! Excellent Video!

[@renaldimrp9425]

Awesome!. I always look forward to your uploads, they're consistently great. Thanks for the detailed and honest review, it helped me make a better decision..

[@gillianyao6976]

Very clear and concise, applied to my worksheet immediately! Thanks

[@TheRandyGr]

Thanks for sharing Kevin. Always great to find out these little things that can really take a project to the next level!

[@dintang2476]

Entertaining!. I really enjoy watching your videos, I can't wait for the next one!. The last one hit me really hard.

[@Cathoray2012]

Excellent tutorial for using drop down lists. I liked the extras at the end of the video - will have to make use of that.

[@sherellebuk]

Thank you, your videos are amazing! Always explained in a clear and simple way that is easy to understand.

[@RemRaye]

I'm taking a Microsoft Office class for a degree, and couldn't figure out how to create survey in Excel 365 until I found this video. Thanks so much for breaking it down into easy to repeat parts!

[@henrykoge8310]

You are awesome Kevin, I have learnt so much from your channel. Thanks for sharing your knowledge

[@foxfields]

THANK YOU! I love the extra features where you can write instructions. I was able to sass my boss about messing up the values in my table :)

[@HarshaSeneviratne-c6x]

Great video Kevin, I keep forgetting how to do this, as its only done occasionally! Thanks for creating the video!

[@Gan8325]

You are so clear and easy to explain things. Thank you for your patience.

[@maulanachafid]

Helpful information. I can tell that a lot of thought went into the making of this video.. The last one hit me really hard.

[@Roseldafigueroa]

Great article to refresh knowledge, I almost forgot this when I stop working. Thanks

[@christinapantouli4783]

Thanks Kevin.I have learnt a lot just watching your videos 😊

[@victorarcos6178]

Thank you sir, very thorough, I understood everything you explained

[@dylalokman]

Thank you! Very easy to understand and manage to create my own drop-down list in excel!

[@oliviaakinyi1068]

Excel is now made easier, Thanks Kevin

[@iRaskulz]

Liked and Subscribed! this video was awesome, thanks!

[@carlabryant3550]

Thank you for these wonderful "how to" videos! Questions re: drop down list: 1.) Can you create a dropdown list in Excel and copy and paste it into Word? will it function? How do you get it to function? 2.) How do you put a blank "value" in your drop down list? Feel free to simply point me in the direction of another video if you have already answered this. Thanks so much for your help.

[@dreudax3294]

Its been long time, but can you do this? Also if it is possible it would be of great help if you can mention some keywords to research into thsi. Thanks.

[@angelagarza2150]

This was so helpful!! I thought it would be difficult to create. You just helped me on how to create schedule for work . I have been manually typing in information.

[@Bardockvision]

As always... you have my answers. Thank you

[@oluwaseyiosagie9333]

Thank you, your illustration was absolutely on point and has just made my life easier.

[@r2sweeth]

You made it look simple!! Thank you for not over explaining

[@_keziaroberts]

Your videos are super helpful! Recommending your channel to my friends right away!

[@abdurahman994]

Thanks brother. Really helpful videos. May almighty bless you.

[@pattyfrick5375]

You videos are awesome...the best I have found so far. Thank you.

[@arthurkklam]

Thank you Kevin. You make life much easier!

[@bncprado]

Hi. Man, you help so many people with your tutorials. Thank you very much. When I create a table and tell the dropdown menu to get info from the table, it doesn't update automatically when I add new items to the table. Am I doing anything wrong? thank you

[@ratgirl669]

The input message and error message was SO useful! Thanks dude

[@megancantley2949]

Genius, I feel like one too 💡👏🏼thank you for this clear explanation 😊

[@spartanadam3935]

Fantastic tutorial, however, mines is not updating dynamically. I do have my list as a table with header in a separate sheet, but it won’t update if I add data to the table.

[@frankdewit3445]

Do u got a awnser already? I got the same problem. cheers

[@spartanadam3935]

@@frankdewit3445 Yes, you’ll create that list as a table (ctrl + T). Give table a meaningful name. Now in data validation use =INDIRECT("CategoryList") where categorylist is your table name. Hope this helps.

[@posentien3283]

This is amazing, thanks Kevin for you sharing!

[@TetsusaigaDrgn]

Thanks kevin...this was helpful and easy to grasp with the way you explained it!

[@michaelhulle8609]

Why are you always the best? Another great one.

[@lauracriado3797]

Now I understand this drop down list... Thank you!

[@nathanpiper1346]

quick and to the point, ty mate

[@rosalesfamily2185]

Love your videos, all of them are extremely helpful. This is going to make my job easier!!

[@elizabethlee4573]

I love your you tube videos. Keep up the good work! They are helpful, useful and best of all , it is easy to follow.

[@Aarontlondon]

Thanks for explaining it clearly!

[@lorrainebingham726]

Oh and by the way, great explanation. I used it for my first try of course there was an item that needed to be added to the list and the user did not know what to do.

[@frosty_fink]

Awesome tutorial! My only issue is that when I am adding new values to my table after defining those specified cells at my list values, they don't automatically appear in the dropdown, like you're doing at 5:30. I followed step-by-step. Do you have any idea why this might be? Thanks!

[@akunnaafolabi3885]

Thanks Kevin, this is very helpful

[@noorkhawaja]

Very helpful video. Thank you.

[@kickingitwithmisha]

Yessss this made my job way easier ❤❤❤

[@FilmBookReview]

Thank you. Helpful. Just used it to create my first drop down menu.

[@riodiaz-o2b]

that was great - I want to see how to change/apply the color palette, based on date range, in a calendar Gantt chart. I used a template, and made changes, but cells don't show the formats I can replicate.

[@tanvigawde1612]

Wow!! This was super helpful!! Thank you!!

[@crisstones72]

You are the best! Thanks ! Anyway you could please show us how to create “consequential (dependent) drop down lists”? Thanks!

[@aldotrillo4642]

Hello, Congratulations, your videos are the best! Please help me with this... How can I include a "Select all" option in a drop down list?, because once an option is selected I can't look all the options again.

[@feyzanuronal2598]

Super helpful! Thanks a lot for the great tips!

[@susanamartinez1504]

This was so useful!!!! Thank you! :]

[@AnaLauraIreta-vk4kh]

Love the great explanation!

[@osPA78]

Quick, simple, and straight to the point! Thank you so much for this video!

[@witchhazel2]

Very clear explanation. Thank you so much! ❤

[@catacoonsmainecoonmagic9416]

A really awesome tutorial, thank you. I do have a question. Once I moved the source list to a different sheet, I was able to add different options (accepted/rejected) to the table but those options didn't appear as an option on the list. Am I missing something?

[@yanniesoo8082]

thank you Kevin! This video is very clear!

[@vickydejager4238]

You a genius! Thank you so much, easy peasy.

[@rithysrey2582]

Hi Kevin, first of thanks for video. It is very useful. I have a little issue when updating list. Automatic list does not update. Please advise, thank you

[@michaelgalik1630]

Thank you, it clear even for me who has very limited knowledge of Excel

[@jennajones9399]

Ditto!

[@hninaye8054]

Thank you. It is so easy to follow and short to the point! Thumbs up!!

[@Muzala_-ny7ri]

Very helpful video... 🥰thank you so much

[@caw4saw]

Is there a way to choose more than one option at a time in a list. Like choose all that apply to a particular situation.

[@diytwoincollege7079]

Thanks. This made it easy!

[@tumbalsatu-vy7uw]

Incredible!. Thanks for the clear and concise instructions, they were very helpful. Thanks for your review, it helped me make a more informed decision..

[@beckhamjclow]

Thanks, I learned and applied. How can I scroll drop list with mouse wheel?

[@abdikadirhillow9875]

very educative,it has really helped.Thanks

[@Monika-nb6ur]

Literally binge watching all your videos, thank you so much for the content! :)

[@amiodynski]

Thanks for the great video. How do I take my list from the drop downs, and let say add each drop down ie; bakery, produce, meet to see how many of each I have?

[@CollectorJoshie2]

Are you able to track how many of the specific values are present and update with changes?

[@MR-ul6bc]

My teammate just quit and I needed to know how to do this. Thanks for posting.

[@TheDarkRobloxian]

Thanks! Noting to myself - I feel like this video could be improved with a moment devoted to whether or not the drop-down could be extended indefinitely down a column, how, and what the implications are

[@sagi662]

Great tutorial! Thank you. I'd rather watch your videos then the Excel tutorials on the Home page 🙂. I really like how to add the messages - never knew how to do that. One question I have is: on the data validation box, settings tab, there are two boxes that are checked by default - what are those about? Should "ignore blank" be left check? Does that mean someone could just ignore the cell and not make a selection?

[@dr.stalins2876]

Excellent Mr. Kevin

[@nikitharebello]

This was very helpful. Thank you

[@natashiawilliams32]

Hi Kevin- How can you use the drop-down list and select multiple selections with a comma and a new line? Can you please cover the VisualBasic process please?

[@santtumakinen8109]

Worked! Thank You!

[@RazgrizRevenge]

dude this really saved my but today thanks for the help

[@brinktruck]

How come when I update the table in which the drop down gets it information the drop down list does not update like your example?

[@Neil1411]

Fantastic video Kevin! Really helpful and intuitive. I would like to ask - is there a way how you can set up a cell which changes according to what you choose in the drop down? E.g. If I choose apples from a drop down menu in cell A1, can there be a way whereby cell B1 will show the price of apples which has been preset in some way? Don't know if it's making any sense....

[@samuelopoku-agyeman9432]

Good tutorials, Kindly add how the drop down can generate a report straight away.

[@hamidfaizi2677]

Thanks for your great tutorials. Few days ago, in excel 365 suggestion was activated for drop down list same excel online, but only for few days was active and after this feature deactivated in my excel. Please assist

[@drdanielroman]

Kevin, Thank you for this. I have a question. the list I create have a particular font and fill format and colour. How can I keep these in the actual dropdown list?

[@iresolvers]

can you do a video about dynamic drop down list to auto add & remove entries thanks you