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

G

Guest

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!!
 
G

Guest

Ali,

This is in the Excel help under the title:

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

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Formula to select a # from a table 2
Excel Excel: How do I put a formula in a drop down list 11
Selective Validation 4
Create Drop Down Box populated by a List 1
Drop Down List 2
Drop Down List 7
Appearance of Data Validation Combo Box 2

Top