How to Create a Drop-Down List in Excel

Learn how to create a drop-down list in Excel - quick and easy.
First, we’ll have a look at how to create a longer drop-down list with more options. Then we’ll try something a little bit different. I’ll show you a way how to create a short drop-down list with only two items – ‘Yes’ and ‘No’.

Don’t miss out a great opportunity to learn:

How to Edit / Remove a Drop-Down List in Excel

How to Create Filter in Excel

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️Timestamps⏱️
0:00 How to Create a Drop-Down List in Excel
0:51 How to Create a Longer Drop-Down List in Excel
2:11 How to Create a Short Drop-Down List in Excel

================

Subscribe and watch more videos that help you use Microsoft Excel quick and easy

Transcription How to Create a Drop-Down List in Excel here

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy

[Purity]

Straight to the point. A big thank you!

[zerolimit]

Ye. Short and sweet, with clear presentation and voice. Hit it!

[alexkisakye]

Simple and straight forward. Thank you!

[danielkono]

Simple and straight to the point ... this video just saved me over an hour of keying in individual responses to a whole bunch of data ... Thank you so much guys !

[dulcem.hernandezg.]

Thank you so much for being precise and simplifying this, this is exactly what I always wanted to learn!! Greatly appreciated, I have subscribed, great content and lessons!

[yuvrajchettri]

So easy and simple,
Very helpful Thank you

[sivakumarl]

Very simple and wonderful video, it's really very helpful 👍

[varunsharma]

Very simple explanation and easy to understand. Thanks for sharing!!

[irmakf]

Very good video. wish you also mentioned the use of ignore blank, in-cell dropdown and apply the changes...

[stonecoldsbottlebin]

Awesome. Simple, easy to follow and no faffing about. Excellent work, thank you.

[Jlovejloveee]

You helped me complete a time sensitive project for work in minutes!! All the way from NYC, I'm saying THANK YOU!

[BarronSaratoga]

Thank you! Very simple and easy instructions.

[mikeb]

Thanks for your efforts here. Very helpful!

[IamCarrieNotBranshaw]

Yeah thank you so much! I didn’t know how to make these until today. Now I can make these without bugging anyone anymore. 😌

[richstevenson]

Great video! Short and sweet! Thank you!

[ruitojais]

Thank you super easy to follow and no bs. It’s appreciated. Sub’d

[kirangurung]

Wow, simple and very clear presentation.

[khalifanikzad]

Thanks a lot, helpful and very short and usable.

[thanatoskatakrima]

Thank you for getting straight to the point!

[TheLowBudgetCouple]

Very helpful and direct to the point. Thanks.