data selection

D

Desmond

I have a list of data provide for other user to key in, but I only want them
to choose from a list, is it possible ?

how to do so ?

Thanks :)
 
T

Teethless mama

Assuming your list A1:A20
select a blank cell
Data > Validation > Allow: select List > Source: =$A$1:$A$20
 
Top