Hi Eric

From menu DataValidationFrom validation criteria select 'List'In Source
mention the range
=$A$1:$A$10

and click OK

--
Jacob (MVP - Excel)


"Eric" wrote:

Does anyone have any suggestions on how to create a pull down lists?
There is a list of values from cell A1 to A10, I would like to create a pull
down list to select any value from this list.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric