cell listbox

[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?

 

[Guest]

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.