try Answers From trianswer.com
0 votes
How to add drop down list in excel?
asked Aug 21, 2010 by triuser (1,781 points)

1 Answer

0 votes
To create a drop-down list from a range of cells, use the Validation command under the Data menu.
Select the cell where you want the drop-down list.
On the Data menu, click Validation, and then click the Settings tab.
In the Allow box, click List.
To specify the location of the list of valid entries, do one of the following:
If the list is in the current worksheet, enter a reference to your list in the Source box.
If the list is on a different worksheet in the same workbook or a different workbook, enter the name that you defined for your list in the Source box.
In both cases, make sure that the reference or name is preceded with an equal sign (=). For example, enter =ValidDepts.
answered Aug 21, 2010 by trianswer (22,754 points)

Related questions

0 votes
3 answers
asked Aug 22, 2010 by triuser (1,781 points)
0 votes
1 answer
asked Aug 22, 2010 by triuser (1,781 points)
0 votes
3 answers
asked Aug 21, 2010 by triuser (1,781 points)
0 votes
2 answers