Create drop-down menus in Excel

[josymarsola]

Very helpful, Thank You!

[IM12356]

Very good and no nonsense tutorial. Thanks.

[xVIPERMAN1x]

Great Thx!

[1pretoriagal]

Brilliant!!

[sudhir5051]

Excellent!!!

[Riiiisc]

thx mate!

[HipHopKitteh]

Very helpful indeed. Please ignore Winnelisjoh. That punk knew nothing of whatever is coming from his/her mouth.

[Winnelisjoh]

Hi Bytebodger it is not my intension to insult or disrespect you but your tutorial sucks.

Why on earth would you, or anybody else, choose to enter all list items, and who knows how many lists are needed, in the same worksheet as were you are going to use the pull down lists in?

I can recommend you to watch the video as well.

And may I make one final suggestion? Remove your tutorial from Youtube

But I guess after you’ve seen the video from Contextures you will.

Watch and learn

[Winnelisjoh]

For all 90 positive voters.... If you think this tutorial is: Perfect, Exactly what you needed, Very helpful and Fantastic I suggest you to check out:

Drop Down List in Excel uploaded by Contextures

I promise you this tutorial will make you even happier then you already were.

For my fellow Thumb Down voter: You will definitely rate this one with a Thump Up

A big BONUS: this tutorial is also available as a step-by-step guide on the website. See link on YouTube.

[rtvoii2]

Thank you! Now if I could only figure out macros

[mochafatdog]

Perfect - exactly what I needed to know. Much easier to create than expected.

[annakikos]

best tutorial, I finally got it...

thank you

[jiminberkeley]

Exactly what I needed. Thanks.

[lindonezz]

Very helpful. Thank you!

[Sharikul]

Thanks..! I needed this for my ICT GCSE (in Britain)

[trr12]

This was excellent!

Thank you!

[brynnetillman]

This was fantastic - THANKS!

[MrPelotero53]

Thanks. Simple and to the point. Nice job !!!

[rrw1250]

Easy to understand. Good job!

[ddpfreddy]

Simple and easy to understand. Thank you!

[DreamKnightz]

is it possible to get the source from another sheet of the excel?

[epiphoneylp]

ty!

[karsuankhor]

thanks for this tutorial, it's short and clear.

[mtnfmly]

Very nicely described!

[RevealUsYourLove]

thank you

[TiubBocor1]

Thank you for this great tutorial. But i got 1 question here. How to resize the font in the list? i tried to change the source font size but it didnt change the font size in the list. Hope somebody can help me. Thanks.

[sehrasamander]

thx so much dear

u have helped me to complete my job work

[kanedakun]

Thanks!!!!  XD

[tangotech32]

Nice Explanation as compared to other videos on the same topic from Different people. Thanks

[theGroveMan]

Is it possible to create a drop-down list in excel that has tag/value features. In other words, I want a list that shows this:

I want to display this in the list.

D-0001-00 [MCT Completion]

D-0002-02 [My other Project]

When they make a selection I want only the Project number.

D-0001-01

[Horchmaster]

@pepiluci75

You have to seprate the words like this January;February;March; April; May at Excel 2007

use the semi-colon

[basmagic]

how can i make 2 lisr. example: processor> intel>types

Amd>Types. if i click on amd i want all amd types and if i click on intel i want all intel types

plz reply

[interdev2003]

thnx :)

[mentalpaul]

you have saved my bacon

[pepiluci75]

For some reason by specifying the list separated by commas I obtaing in the drop down menu a unique string 'January, February, March, April, May' and no other options in the drop down. Is there anything I'm doing wrong?

[nosredna2]

Thank you!

[charmingkevin4u]

THANK YOU SO MUCH MAN THIS HELPED ALOT

[Colheat232]

Extremely helpful! Thanks!

[VanLtheMan]

What do you do if you need select multiple selection from dropdown menu?

[obellech]

This was exactly what I needed... Thanks

[LifeInReturn]

I have Excel 2003. This was SO helpful. Just awesome! Thank you!!!

[spence341]

how can you choose the colour of the boxes aswell in a drop down menu?

[yelnazty]

thanks nika, helped a ton..

[jimme1982]

Is it possible to creat a search option in top of the drop down list? If I have a list with 100 different options, it takes a long time to find the correct one if I have to sort through them manually. With a serarch option it would be a lot easier.

thx. in advance

[reilyverizon]

great! job....thanks for your help

[peddewop]

(Please respond to my queastion below)

btw I tried as explained in this vid...but instead of a vertical list I get my entered values horizontaly...and I cannot select one of them..it just seems t be 1 big value (displayed just as entered in the source box)...how come? And again..I don't think with this option I can do what I want as explained in my post below..

[peddewop]

*question below

I have Office 2003..(I believe the older version it worked by just right clicking on the cell you wanted to make a drop-down list)..I guess this explanation also goes for 2003 version, but just in case

[peddewop]

Hello, I try to make a drop-down list but not even sure if that's the correct name. I have a list (vertically) with values. I want to make a drop down list(1st empty field above this list) in which I can select one of the values in order to display only that part of the list that equals the value selected. Hereby the data in rows should be fixed..means that the data in other collums will move along when you select a value in the dropdown list (so rows don't get mixed up..or how to say)

[yigalpr]

Thanks, many thanks. That´s why you should keep doing this.....you help people man.

And, yes it works in Excel 2008 for Mac...

[djdeluxe76]

Thanks for posting that. Works in Excel 2008 on Mac as well.

[dechandi]

thanxs man, been looking how to do this for a long time!

[luvguy86]

hey itz really helps. thnx buddy.

[XCUREANDDISEASE]

Thanks ALOT!!!! Very good, nice.