Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2005

Tip: Looking for answers? Try searching our database.

vlookup

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
excelnewbie - 18 Sep 2005 01:21 GMT
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 :)
Debra Dalgleish - 18 Sep 2005 14:46 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.