| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i use a combo box or drop down list to preform a calculatio | Excel Worksheet Functions | |||
| Drop Down List Box, Combo Box | Excel Discussion (Misc queries) | |||
| accessing graphics with combo box or drop down list | Excel Discussion (Misc queries) | |||
| How do I create a combo drop down list in Excel? | Excel Worksheet Functions | |||
| Drop down list or combo box help needed | Excel Discussion (Misc queries) | |||
Linear Mode
