Advanced Excel: How to Create a Drop Down Box in a Cell

[roeelo]

great and very informative tutorial.

[JohnnyGeary1]

Great Video! How would I be able to select more then one item within the drop down box?

[monasalem123]

Comments of viewers are great too! I did not know what the mark in front of Title was in the Source Box. Got it from the comments.

[NPRMc]

=Title (or whatever you want to name your list)

[pmurphs09]

Thanks BRO!!

[ramidagan]

Great!! thanks.

[uneek285]

THIS WAS A LIFESAVER!!!! THANKS A BUNCH!!!! 

[zacnok]

After you have created a "drop down box", how do you edit the "drop down options" if you forgot one or two?

[MandD1331]

awesome!

[kieah]

Great apart from the fact that I am a total noob to excel. I could see there was something before "Title" when entering the source but I couldnt tell what it was - so I had to read through a different tutorial to get that piece of info. I know this is advanced excel and the equal sign is a basic thing, but I think it would be better to accomodate all levels of users where possible. Anyway thanks for the tut...I got a drop down box and thats what I was aiming for.

[klined]

@kieah

he typed =Title

the equals sign is used a lot in excel for assignment

[soniaho88]

Thank you!

[AR15VET]

In the Data Validation, What was it that you typed before Title. The video is kind of blurred. Thanks

[kkkollio]

What exactly are you tiping for Source?

[incorporatedfx]

In that box, what did you type in before "title" it looked like "otitle"

[Prisha22generic]

Thanks !!! it was nice

[sebargentino]

i have a home sheet 1 and sheet 2 and sheet3

now i sheet 1 i spent 50 dolars so it will appear in sheet 2.

now i try to put new columns in 1, and i put the # but nothing appear in sheet 2.

how can i make it work?

[jlfouse]

Worked like a champ! Thank you for the video :)

[pwmorton321]

Loved it!

[Mugambo1111111]

Good. But what if you wanted to select multiple answers?

[Boaztublecain]

Excellent. Thank you very much.