You could just name the range that you want to have a drop down in, and use
that in data validation.

If column A has a list of names, go to insert, names, define, type in
"Names" select the range. Then go to data validation, list, type in "=Names"

Otherwise, I agree with davesexcel, in that some clarification is needed.

"Alfredo" wrote:

The file is 2.7M and its only has 10 list of dropdown on every row, and what
is that option?
thanks