Excel Drop Down List Tips and Tricks

Learn everything you need to know about using drop down lists in Excel. I'll show you some tips and tricks that you've probably never seen before.

Contents 0:00
1. Simple List 0:33
2. List from a Table 2:37
3. Unique List 4:14
4. Dependent List 5:51
5. Searchable List 5:56

#seletraining #excel #dropdownlist

[Luis]

Thanks a lot for sharing! Precise and direct!

[mirrorreflection]

The creator of Excel should award you for making complex things so simple for a layman ...

[JanSnoek]

thanks so much for your very clear explanations!

[wangzig]

Thanks sir, the only tutorial and simple method that worked. Excellent

[ingGS]

I just found your videos and they are great! Thanks for the tutorials.

[wayneedmondson]

Thanks Jason. Nice examples. Dropdown lists are both useful and fun! Thanks for sharing :)) Thumbs up!!

[Donna-ffty]

Love your tutorial with superb cool deep voice. So clear and precise. 💗

[chandaatanu]

Very good narration with lucid explanation.

[jimmyPOUFAJones]

Great information, my dropdowns are so

[jacktoddy]

Really useful - Many thanks, you helped me considerably.

[cogwheelLearning]

Wow! I guess I picked the wrong timing to post a similar video. Nice work Sele Training!!

[andysut]

Simply superb, clear, precise and well demonstrated thank you.

[maikelmetry]

Thank you so much for your great effort 💗

[drafthustletv]

Great Video. Is there anyway to have each item in the drop down to only be used once? Thanks in advance!

[Blerrian]

When dealing with array formulas, you can just reference the cell with the formula in it and add # to it, instead of the entire column.
It will update automatically and you won't have all those blanks in your list.

[stephaneenglish]

Well paced and clear explanation. However, you’re encouraging people to name fixed ranges of cells instead of using the more advanced feature of Excel: tables (from the Ribbon: Insert >Table), with structured referencing.
There are lots of benefits to formally defining tables within Excel wherever you have a list, instead of just making a fixed block of cells. One of the benefits is that they can be reordered by drag and drop. Another is that entries can be added and the table will dynamically resize to include them. Within the data validation pop-up window, you can use indirect addressing name the table as your lookup list.

[grizzygriz]

Great tutorial. Thank you. It would be nice if you can zoom in a little when you type the info in data validation screen. I maximized my screen and it’s still hard to see what you entered in the “source” field.

[charliemutungi]

Thank you for this insightful tutorial. Quick question on the Searchable Drop List, is there a way to use the Data Validation on a table referencing to several cells on each row? I did a searchable list but cannot apply this search to the next rows as referencing is locked on one searchable cell.

[vickybelinda]

Hi i wanted to ask is it possible if i have a task list and i wanted to make it into drop list as a checkbox, for example, i click 1 name its auto come out the details then the list we need to prepared in 1 column