blank top line in a drop down box

  • Thread starter Thread starter tates
  • Start date Start date
T

tates

I want the first line in the drop down box to be blank - can anyone tell me
how to do this?
 
For a Data Validation drop-down, just make sure the first cell in the
validation list is blank.
 
I went to INSERT/NAME/DEFINE and changed Refersto: to include a blank line
plus the cells with the list I do want.
Then I tried typing the word BLANK - changed the type to white so it
wouldn't show, that didn't work either.
 
It might be there, but not easily recognizable. Try putting the blank as the
second item in the list, not the first.

What happens?
 
I added a Validation Rule and got the blank line. Thanks for your help
 
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
Drop down boxes 1
Recording new Macro won't reset drop downs 3
Drop down 1
excel drop down box used conditionally based on previous input 1
remove drop down box from a cell 1
Excel Excel: How do I put a formula in a drop down list 11
Auto filter drop down box 1

Back
Top