drop-down list(or combo-box) for the cell
 

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

drop-down list(or combo-box) for the cell
 

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

drop-down list(or combo-box) for the cell
 

Maybe you can use Data|Validation

Debra Dalgleish's has notes:
http://contextures.com/xlDataVal01.html


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

--

Dave Peterson