How to add Drop Downlist in Excel 2010

Published on July 1, 2010 by Admin

Filed under Excel, MS Office

Last modified October 9, 2014

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 1746 times

Drop Downlist in Excel 2010

A drop down list allows you to enter data into an Excel from a list of data. This makes the data entry easier .

When a drop down list is created , an arrow next to the cell is displayed .You can enter the Data in the cell by selecting the data in the drop down list.

How to add Drop Downlist in Excel 2010 ?

It is quite easy to add the Drop Downlist in Excel 2010 .

To create the Drop Downlist in Excel 2010, first add the list for the datasource .

To create the list for the drop down ,enter the data in a single column cells

B4 – tiger
B5 – lion
B6 – elephant
B7 – dog
B8 – cat

The list can be added from the Data tab -> Data Validation ribbon .
Select the cell / column where the drop down list should be displayed and choose the datasource in the following window.

How to add Drop Downlist in Excel 2010

Now the dropdown list should appear as shown below.
Drop Downlist in Excel

 

Tags :

13 Comments

  1. Ivan Rmz

    great tks for the info.

    February 2, 2011 - 7:18 pm

  2. Abeer

    Thanks fot the great help..

    February 28, 2011 - 8:26 am

  3. Jamie

    Amazing, thanks very much! Can you link the drop down lists? So if i select option A for example, in the next column i can only select options that relate to the answer in the previous column? Hence gathering related information as you progress through the columns… i imagine i might need a macro for this!

    April 21, 2011 - 1:06 pm

  4. Thanks alot!
    Now all I gotta do is to learn conditional formatting :)

    May 16, 2011 - 3:19 pm

  5. Biohazarus

    @Abeer: Try something like this, worked for me. =IF($B1=”OptionA”,ListA,IF($B1=”OptionB”,ListB,ListC))

    But what I want is instead of ListC I want to see ListA+ListB. Any clue?

    August 10, 2011 - 6:41 pm

  6. Excellent info. Not too much detail and right to the point. Thanks for posting.

    August 11, 2011 - 8:38 pm

  7. Senthil Kumar

    :)

    August 13, 2011 - 6:27 am

  8. scott

    how is this excellent info, all it does for me is show me where this button is. What do i do after the box opens up. Where is a good site at to learn how to use this so call resourceful program. I know if you go to college they probably teach you how to use this fantastic program. But you know what this program is a pain in the butt. Does anyone know of a dummie version that will teach me how to use excel.

    August 21, 2011 - 2:52 am

  9. Buchi

    when I reopen the saved excel sheet, it was disappearing drop down list.Do I need to do the validation of each time open?

    August 24, 2011 - 8:02 pm

  10. kashif

    too mush thnks to provide us drop downlist information but can u plz show how to use drop down list connect to other sheets

    September 4, 2011 - 8:27 pm

  11. Find Available Keyboard Shortcuts in Excel 2007 | Tech Blog
    October 29, 2011 - 11:47 am

  12. Ron Zurawski

    Can anyone help with this. A user told me about excel spreadsheet, that had dropdown lists in some of the columns. If you click on the 1st cell under one of the titles, the dropdown shows 6 items… If you go to the cell below the 1st, hit the dropdown, there are only 5 items, and so forth..
    XP / Office 2010 works fine. Win 7 / Office 2010, this happens…
    Any Ideas…

    November 18, 2011 - 10:54 pm

  13. tom burns

    excellent post. what I need is a drop down that reveals a material such as paint $10 per gallon. primer $3 per gallon that will multiply the results of another drop down menu such as 20″ wheel. so if the paint is 10 and the 20″ wheel uses 1/10 gallon the result would be displayed in another cell.

    January 4, 2012 - 3:10 pm

Leave a Comment