Hey.
I am using several drop down lists in a worksheet.
Some of the drop downs show the items starting at the top of the list,
others start half way through a list.
Can i make then all start with the first item on the list?
Thanks :)
When you open the Data Validation dropdown list, it takes you to the
first item that matches the cell contents. If the cell is blank, and
there are blank cells in your data validation source list, the first of
these will be selected in the dropdown list.
To prevent this, remove the blank cells from the data validation source
list, or have a default entry in the cell, and the list will open to
that item.
> Hey.
> I am using several drop down lists in a worksheet.
[quoted text clipped - 3 lines]
>
> Thanks :)

Signature
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
excelnewbie - 19 Sep 2005 09:27 GMT
Thanks Debra :)
> When you open the Data Validation dropdown list, it takes you to the
> first item that matches the cell contents. If the cell is blank, and
[quoted text clipped - 12 lines]
> >
> > Thanks :)
excelnewbie - 19 Sep 2005 09:29 GMT
Hi Debra.
I have a named array in the source text box rather than just cell references.
The named array has absolute references i.e. $c$1:$c$50
I have several empty cells included in the array to allow for additional
values later.
The cells that have information in them are at the top of the array tho...?
> When you open the Data Validation dropdown list, it takes you to the
> first item that matches the cell contents. If the cell is blank, and
[quoted text clipped - 12 lines]
> >
> > Thanks :)
Debra Dalgleish - 22 Sep 2005 17:31 GMT
Instead of leaving blank cells, you could use a dynamic range as the
list source. There are instructions here:
http://www.contextures.com/xlNames01.html
> Hi Debra.
> I have a named array in the source text box rather than just cell references.
[quoted text clipped - 19 lines]
>>>
>>>Thanks :)

Signature
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html