list box

F

frendabrenda1

I have created an in-cell drop down box that works perfectly, except that it
shows blank until you scroll to the top of the list. Is there a way that it
would show the first option in the list, rather than start at the end?
 
D

Debra Dalgleish

If the cell with the data validation list is blank, and there is a blank
cell at the end of the source range, that's what will be selected when
the list is opened.

If you're leaving blanks so the list can grow, you can use a dynamic
name for the range instead. There are instructions here:

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