Excel Drop Down List Tutorial

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

awesome dude

great...

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

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

Love your videos!

Cool

Yessss this made my job way easier ❤❤❤

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

What is the best way to add date picker calendar in a drop down menu in excel?

The top line already is formatted and has arrows... I'm creating a list myself. How do you start from scratch? This vid was very frustrating.

When i update my Type list from another sheet, it doesnt update on my dropdown list. Any idea, whats the issue ?

Do you provide on line classes? I would like to take an excel class. Do you have any recommendations? Thank you!

how can i colour code options in drop down box

You said you can create the list in another worksheet but didn't show how to get it into another worksheet. When I try it, how do I name the "source"? The table created has a name but that doesn't work when I type it into the source field.

thank you

I would like to have the option to choose multiple selections in a cell by using a check box. Say if I want to choose 7 of the 16 counties in Maine in one single cell, is this possible?

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

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

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?

Very clear explanation. Thank you so much! ❤

God bless your soul!

My son was tasked with a summer project for school that involves excel. Basically he needs to put traffic lights in our county and find them according to their intersections. I have searched all over for the last 4 weeks and can't come up with anything that is helpful. Is there a way to create a drop down list for streets that run north and south, east and west, and have the intersections populate based on the first selection? So if I have 10 traffic lights on apple ave, can I have the 2nd drop down list populate intersections that only cross apple ave?

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

Love the great explanation!

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.

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

Is there a way to do a drop down list with different color cells?

Liked and Subscribed! this video was awesome, thanks!

Is there a way to select multiple items in a drop down list?

Thanks

You talk to much! Get to the point. I've lost interested and moved on to another video

one deficiency is it does not have predictive text (for example: if an option in the table is FOOD, the word will come up automatically when I start typing F.. if there are no other similar options). This is a time saver. Can it be incorporated?

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.

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

Thank you so much.

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.🎉

why the items I add to the table don't appear in the drop down list?

Can you make a drop down list that works so that if you select Sheet 2 you get Sheet 2, so if I have a lot of sheets I can select a sheet in a drop down list or if there is another better way it would be cool to see it?

Can I add a check box in a drop down list?

Please can we do a drop down list that selects colors

Why everytime I add an item to my database it says "a user has restricted values"? Can anyone help me?

This was very helpful. Thank you

This is amazing, thanks Kevin for you sharing!

Hi Kevin,I have been following your channel for a long time,just wanted to add that I am unable to insert the calendar in Microsoft 365.I could not find any option for it and you cannot add the downloaded one in a protected view. Please ask Microsoft to add a Calendar pop up as a field in Excel 365.

Thank you! Great tutorial!

As always, you make it clear and easy to follow. Thank you Kevin.

How can I sort my drop down alphabetically?

Neat, thanks Kevin!