Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down List
How do I set up a drop list, when my list is on another worksheet within my
workbook? |
#2
|
|||
|
|||
Name the list, say, "my_list", and use the name in the Validation
dropdown: =my_list In article , "jabernathy" wrote: How do I set up a drop list, when my list is on another worksheet within my workbook? |
#3
|
|||
|
|||
following on from John's answer -
to name a list, select your list and then click in the name box (left of the formula bar, above column A) type a name (no spaces, can use underlines, start with an alpha character) and press ENTER (doesn't work if you don't press enter). you might also like to check out Debra Dalgleish's website on Data Validation for ideas on what you can do with data validation and dynamic range names (i.e. so if you add new items to the named list, the range name grows to accommodate them) www.contextures.com/tiptech.html Cheers JulieD "JE McGimpsey" wrote in message ... Name the list, say, "my_list", and use the name in the Validation dropdown: =my_list In article , "jabernathy" wrote: How do I set up a drop list, when my list is on another worksheet within my workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
Drop Down List | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |