T
tates
I want the first line in the drop down box to be blank - can anyone tell me
how to do this?
how to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
For a Data Validation drop-down, just make sure the first cell in the
validation list is blank.
validation list is blank.
T
tates
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.
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.
G
Gary''s Student
It might be there, but not easily recognizable. Try putting the blank as the
second item in the list, not the first.
What happens?
second item in the list, not the first.
What happens?
T
tates
I added a Validation Rule and got the blank line. Thanks for your help