Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

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

Loading...

Sign in or sign up now!
135,782
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 24, 2008

Learn how to create a drop down box in a worksheet cell using the Data Validation function.

If you would like to learn more about Microsoft Excel visit our website - www.NQTraining.com/learnexcel.asp

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 9 dislikes

Link to this comment:

Share to:

Top Comments

  • Excellent. Thank you very much.

  • 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.

see all

All Comments (21)

Sign In or Sign Up now to post a comment!
  • great and very informative tutorial.

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

  • 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.

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

  • Thanks BRO!!

  • Great!! thanks.

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

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

  • @kieah

    he typed =Title

    the equals sign is used a lot in excel for assignment

  • awesome!

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more