Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List
I have created a validation drop down list, when I go to pick items from the
list, why does it not show the 1st name on the lsit, sometines the list sohws only the last 2 names. I have some blank cells in my range, as I want to be able to add names to the lsit in the futrer, is this what is casuing the problesm? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List
I'd guess that you're using a dynamic range name and you don't have that set up
correctly. See Debra Dalgeish's site for some nice tips: http://contextures.com/xlNames01.html#Dynamic If you still have trouble, post back with more details. JackR wrote: I have created a validation drop down list, when I go to pick items from the list, why does it not show the 1st name on the lsit, sometines the list sohws only the last 2 names. I have some blank cells in my range, as I want to be able to add names to the lsit in the futrer, is this what is casuing the problesm? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |