Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I insert A drop down dialog box as a 'list to choose from'?
Can you please tell me how to add a dropdown control box (in simplest form)
to list the following to choose from: P-112 MERCY-GILBERT P-117 OPUS-PIMA P-129 MAGICAL MIDDLESCHOOL and so on. These are our construction sites, so I need to be able to add/delete to this list as needed. Thanks |
#2
|
|||
|
|||
You can use data validation to create a dropdown list in a cell. There
are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html Rochelle B wrote: Can you please tell me how to add a dropdown control box (in simplest form) to list the following to choose from: P-112 MERCY-GILBERT P-117 OPUS-PIMA P-129 MAGICAL MIDDLESCHOOL and so on. These are our construction sites, so I need to be able to add/delete to this list as needed. Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thanks, your link worked!
"Debra Dalgleish" wrote: You can use data validation to create a dropdown list in a cell. There are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html Rochelle B wrote: Can you please tell me how to add a dropdown control box (in simplest form) to list the following to choose from: P-112 MERCY-GILBERT P-117 OPUS-PIMA P-129 MAGICAL MIDDLESCHOOL and so on. These are our construction sites, so I need to be able to add/delete to this list as needed. Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions | |||
Insert column entries from a master list | Excel Worksheet Functions |