data selection
 

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 :)

data selection
 

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




"Desmond" wrote:

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 :)