Ali,

This is in the Excel help under the title:

"Create a drop-down list from a range of cells"

Dave

"ali" wrote:

how do i make drop-down list(or combo-box) for the entire column ?

for example:

I want every cell in Column 1 to have a drop-down list so i can choose
either "001", "002", or "003" and only


thank you all experts!!

--
Allen Phailat Wongakanit