It may be either plaint text column or dropdownlist column
user can be able to select a range in a column
the value of the first column has to be updated in remaining cells
help me on this
You'll have to explain this question in a little more detail.
So far, it sounds like a user selects a range of cells in a particular column and then some value changing happens somewhere, but that part of your question didn't make much sense and is incomplete. Where would the values change? What's the purpose of selecting multiple cells?