How to create drop down list?

  • Thread starter Thread starter aheitner
  • Start date Start date
A

aheitner

How do I create a cell such that the user has to select from one of
selections in a drop-down list?

For example, column A is called "Contract Length" In each of the cell
of column A, I'd like the user to select from only 3 choices: 12, 24
36.

Thanks,

Andre
 
You can use the DATA VALIDATION feature. Here's how:

First enter the available values you would like to appear in the dro
down list in several cells. For example enter 12, 24, and 36 in cell
B1,B2, and B3 respectively. Next click on Cell A1 and choose DATA --
VALIDATION from the menu at the top of the Excel Workbook. Whe
prompted for the ALLOW values click the drop down menu and selec
"LIST." After selecting "LIST" you will be prompted to select th
source of your data in the validation list. Just click the icon to th
right of source textbox and then you can then click and select th
cells containing the available values (B1 through B3.) After selectin
your source cells, click ENTER and then click OK. You now have a dro
down list containing the values you entered. You can now copy the cel
containing your drop down list to all cells in column A and you can no
hide column B so that the validation values do not appear on th
sheet.



Rolli
 
Back
Top