cell listbox

D

ddumke

Someone at work sent me an Excel file that had a neat
feature in it. Each cell had a down arrow. When this
arrow was clicked, a list of values appeared from which
you could select one and the cell would contain that
value. Does anyone know how to do this?
 
M

medialint

Yes. It's Data Validation.

1. Select the entire column you want to apply this to (by clicking on the column header so the column highlights)
2. Go to the Data menu > Validation ...
3. Under the Settings tab of this dialog, the field "Allow" drop down to "List"
4. In source (presuming it's a short list) type your values separate by a comma. For example: Apple, Orange, Strawberry, Watermelon.

Hit ok.
 
Top