Related Posts Plugin for WordPress, Blogger...

Excel Drop Down List and Validation

This is a great tip especially for those who are having a blog contest. By the way my $200 blog contest ends this March 15 so join now. Since my contest is by points system, I tally the score using the help of Microsoft Excel. To make my life easier in typing the words I usually use, I created a drop down list for a certain column.

Here is the sample worksheet of my tally sheet:
Excel Drop Down List and Validation

Column F by the way has the drop down list that I am discussing. To create that drop down list in Excel, you need first to define a name. At the Insert menu, select Name then the Define selection. Label your desired name then followed by placing the range of the selection you want to appear in the drop down list. In the given example, my range is E2 to E17 of “PT Value” worksheet. Click the Add button afterwards.
Excel Drop Down List and Validation

After we have defined the name, we need to add the validation in the cells. In this case, highlight the entire column F. Go to the Data menu followed by selecting Validation. At the settings tab, select List from the Allow drop down list. At the source text box, type the name of the defined name earlier. Make sure to type an equal sign before the name.
Excel Drop Down List and Validation

Voila, you should be able to see the drop down list that you have created.

If you like this post, buy me a cup of coffee.

Share This Post Digg This Furl Reddit Fav This With Technorati Yahoo MyWeb Stumble This


  1. Hi! I'm Grace  

    March 5, 2009 at 3:11 AM

    I was here again... dropping EC :)

  2. topen  

    March 5, 2009 at 7:35 AM

    hei mak im subscribe via email, to joining your bigmak blog contest


  3. Sherry  

    March 5, 2009 at 11:54 AM

    Excel is very useful!

  4. Sherry  

    March 5, 2009 at 12:05 PM


  5. sweet_shelo  

    March 5, 2009 at 1:25 PM

    Good info Makoy.. Thanks for sharing..

    By the way I have linked this blog to mine also.

  6. Denis  

    March 5, 2009 at 1:34 PM

    ive heard about all these beautiful wonders of excel, but still im a sucker at this hehe

  7. Rosa  

    March 5, 2009 at 3:37 PM

    WOW! Interesting, very useful! tweet this:

  8. Dinah  

    March 5, 2009 at 4:19 PM

    this is a nice tutorial by the way, even for people like me who are not familiar with excel's drop down menu. i only know sorting :-)

    btw, I am entering all my 4 blogs to your contest. how will you know that I own all those blogs? these are the blogs:

    also, i subscribed using my 3 email addresses :-)

    I am just confused how you will put all those points under my name?

    oh well, goodluck on your BIG contest!

    ps, does this qualify as a quality comment, worth 2 pts? :-)

  9. Sherry  

    March 6, 2009 at 12:19 PM

    my way of using the excel is different from yours.

  10. Sherry  

    March 6, 2009 at 7:52 PM

    I forgot to tell you I also use emails to check on the entries like when there is comment we sure get the email right? So there is where I check too.

  11. Sherry  

    March 7, 2009 at 3:26 PM

    I think you will be good teacher guiding newbie to use Excel.

  12. Anonymous  

    March 7, 2009 at 4:49 PM

    Hi! Helpful tips!!!

  13. Sherry  

    March 8, 2009 at 1:12 PM

    I truly think you are more organized than me. :)

  14. Sherry  

    March 8, 2009 at 1:12 PM

    this is good tips for those that going to start a contest! I mean contest that need contestants to gain more points.

  15. Sherry  

    March 10, 2009 at 4:37 PM

    I think the way you do will let you know if the link has been use or not. :P very effective yeah :)

  16. Rolly  

    March 11, 2009 at 4:28 AM

    I'm not very good in excel but I am trying to learn.

    dugg, twitted baconchezjoro and make a comment - Cheap domain name registration, renewal and transfers - Free SSL Certificates - Web Hosting