How to add Drop Downlist in Excel 2010
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.
There are other ways of creating Drop Downlist in Excel too with the different datasources…
You can find the series of posts on Excel , drop Downlists in Excel , and MSOffice in the MSOffice Category of the TechBlog-Ginktage
Recently Searched terms :
- excel 2010 drop down list
- drop down list excel 2010
- excel drop down list 2010
- how to create drop down list in excel 2010
- create drop down list in excel 2010
- how to create a drop down list in excel 2010
- drop down list in excel 2010
- how to add drop down list in excel 2010
- insert a drop down list in excel 2010
- how to insert drop down list in excel 2010
- create a drop down list in excel 2010
- creating a drop down list in excel 2010
- how to make a drop down list in excel 2010
- insert drop down box in excel 2010
- drop down menu in excel 2010
- how to insert a drop down box in excel 2010
- drop down menu excel 2010
- how to make drop down list in excel 2010
- excel 2010 create drop down list
- how to create drop down in excel 2010
great tks for the info.
Thanks fot the great help..
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!
Thanks alot!
Now all I gotta do is to learn conditional formatting
@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?
Excellent info. Not too much detail and right to the point. Thanks for posting.
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.
when I reopen the saved excel sheet, it was disappearing drop down list.Do I need to do the validation of each time open?
too mush thnks to provide us drop downlist information but can u plz show how to use drop down list connect to other sheets
[...] find the available keyboard shortcuts in Excel 2007 , press / Hold down the ALT [...]
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…
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.