list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Are you sure you don't have some blank cells selected in your vaildation?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Create Drop Down Box populated by a List 1
Data Validation drop-down 5
viewing a list 3
Size of drop down in validation list 2
drop down list 1
Drop Down List 2
Position of a drop-down list 5

Back
Top