How to create a pull down lists?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
Hi Eric

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

and click OK
 
Back
Top