drop down box

[jms54]

I have made a drop down box using data validation. When I go to an empty
cell and click the dropdown arrow, it goes to the first blank cell which is
the cell after all my data. How do I make the dropdown box go to the first
item in the column of data. Thanks

 

[JE McGimpsey]

I have made a drop down box using data validation. When I go to an empty
cell and click the dropdown arrow, it goes to the first blank cell which is
the cell after all my data. How do I make the dropdown box go to the first
item in the column of data. Thanks

I'm having a hard time visualizing what's happening.

First, while I don't think it makes a difference here, you should always
specify which version of MacXL you are using.

AFAIK, you can't change the behavior of the dropdowns. I *think*, for
XL04 and XL08 the logic is

1) If the entire list can be displayed entirely below the cell,
the list shows up below the cell and to the left.

2) If the entire list can't be displayed below the cell, but it can
be displayed entirely above the cell, the list is displayed above
and to the left

3) Otherwise, display the list to the right of the cell, with the
bottom of the list at the bottom of the screen.

If that's not what you're talking about, post back with a little more
description.

 

[jms54]

I have a drop down box that I am just making by data validation. the drop
down list is linked to a column of data on the same workbook. When I go to a
blank cell that hss been formatted like this and click on the arror to make
the drop down box appear, I get my drop down list. It works just fine. The
problem is that the drop down list does not start at the first entry in my
list. It starts in the cell after all my data. so it is blank. I have to
scroll up in the drop down list to see any data. I am using excel 2007.
Thanks

 

[JE McGimpsey]

The
problem is that the drop down list does not start at the first entry in my
list. It starts in the cell after all my data. so it is blank. I have to
scroll up in the drop down list to see any data.

Are you sure your list is defined correctly? I don't see this happening
in blank cells - the list always appears with a list item adjacent to
the cell.

I don't see this in XL07, either, though the dropdown's different.

But this is a Macintosh XL newsgroup (hence the ".mac." in the newsgroup
name).

You may have better luck posting to

microsoft.public.excel.misc