🤔 How to Create a Drop-Down List in Excel

Drop-down lists in Microsoft Excel allow the user to select text or values from a list of options, instead of typing them manually in a cell. This reduces errors during data entry. The drop-down list is the most popular data validation tool in Excel.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[tlubaina]

I love when creators make straight to the point, no-fuss content. A massive thank you for the brilliantly quick tutorial!

[eliseevsgk]

The second method I didn't know. Thanks

[FutureCommentary]

Back to basics. Was so surprised to see this given your more recent content that was been about new excel features and stuff.

[OlalekanAdeeko]

Thanks again Leila, I so much love how you create your videos, always clean and smooth

[shabynathroshan]

you are just amazing, long time fan. I am loving your short tutorials

[CorvoFG]

Very useful, never knew you could type straight into the parameter box!

[mohammadj.shamim]

Leila is the best. Thank you very much.

[nadeeshapalliyaguru]

Thank you for presenting it without crap like intros!

[selvams]

Thank you very much. Have been watching your videos to help us move from GSheets to Excel. Simple and clean tutorials.

[dnceozd]

concise and to the point, nice voice, thank you

[dorjeearieh]

I'm just loving your channel. I learnt so much today. Knowledge is power for sure. Thank you. Peace and love from India ✌️

[revathyvlogs-yt]

Thank you so much 👍.... Very clear and smooth explanation.... Thanks a lot

[Tech-mxyp]

Exactly what I’m looking for. Thank you so much. New subscriber here.

[phyuzar]

I search 4 hours and finally I've got it. Thank you so much.

[danialahmadmir]

I love the way you teach ma'am 🎉❤

[damorgman]

Great video as always. I noticed on your lookup sheet you had a title for the lookup list. I usually name the lookup list range to match the title (without spaces of course).

[NedumEze]

Leila, Thanks for the tip.
Been looking for this. But not just being able to make a drop down list but also to enable selections to change the spreadsheet population. Can it be done? If yes, please, how?

[lqtmn]

Ah ha! After a dozen shorts I finally came across one I already knew.

[kaia.giermann]

Good refresher👍
But now: Make a drop-down list from a sorted and filtered or somehow calculated list... That would be great help 🤔

[mshanabar]

When I got this notification i thought excel introduced something new in drop down list 😅 but nothing new.. wonder what made u upload this video