Creating a drop-down list in Excel 2013

This video teaches you how to create a drop-down list using Excel 2013. You can apply this technique when working with large amounts of information to create a consistent set of records. This will make a massive difference if you have multiple staff working on the same document.

If you have questions or would like to suggest something for my next video, please comment below.

[JNNFER]

Awesome, took me less than a minute after viewing your video oppose to almost 30 mins searching through the help section on Excel!! 👏👏

[natschmat]

Thank you so much.  I just watched this to help me with a spread sheet I was making for my job.  I watched another video that made this seem so unnecessarily complicated, but your tutorial was quick and easy to follow.

[chileanexperiment]

Straight to the point. 2 minutes +
excellent video ! THanks for sharing!

[AndrewNguyen]

Short and sweet to the point. thank you!

[mohamedmekkati]

Thank you very much for your Straight to the point explanation.

[waltercamacho]

This was great! Simple and direct. Fantastic job.

[BayAreaFreeride]

Thanks, very quick, to-the-point and clear.

[madkittenguia]

Thanks! Short and Sweet! Very Helpful 👍🏼👍🏼👍🏼👍🏼

[Siendo]

Thank you! That was clear, quick and really helpful!

[aartinaravane]

Thanks a lot!
It saved my lot of time!

[sgpradeep]

Wow awesome man. Damn quick. Microsoft should put this video for the help sections. Spent unnecessary time reading those. With your video I could make it in 10 seconds.

[balaalhassan]

Thanks alot master, this is really helpfull.

[willimacdo]

thanks for the putting up the information. It was a bit fast for a 'first timer', but that's what the pause button is for right?

[GrenPara]

Hello, Thanks for making this video it really helped me. I do have one question thou.
When i make the drop down list how would I add items to the list later?
For example if i have a list with 10mg, 50mg, 300mg and I find out later i need to add 150mg how could I add it to the list at later date?

Thanks
Gren

[HTcobras]

I'm assuming you can use this with vlookup. Very handy

[CPhase]

I'd like to know how to make the drop down appear (after the list is created) when you single click on the cell. Some people do not pay attention to the fact that there is a drop down, and they start typing in the cell, which returns an error.

[BufiniPinoy]

how do you apply it to the whole column?

[MyWorksheet]

Check out my new video. Learn how to find and remove duplicate records in Excel 2013: