Drop Down List

[John]

Is there a way using Data Validation list - for the list to 'open' at the
top of the data. Anytime I use this feature the list always starts at the
bottom

Hope that makes sense

Thanks

 

[Debra Dalgleish]

There is probably a blank cell at the bottom of your list source. When
the dropdown list opens, it matches the cell value to an item in the
list, if one exists.

Delete the blanks from the source, and the problem should disappear. If
you're leaving blanks so the list can grow, you can use a dynamic name
for the range instead. There are instructions on my web site:

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlNames01.html

 

[John]

Thanks Debra, thats exactly the problem and exactly the reason why I left
blanks