Cell Validation "Ingnore Blanks" doesn't work

[keithb]

As best I can tell, Cell Validation drop-down list "Ignore blanks" does not
work, since blank lines referenced from another worksheet show up the
drop-down list.along with lines that are not blank. Is there some way to
eliminate blank lines which show up as gaps in a drop-down list?

Thanks,

Keith

 

[Norman Jones]

Hi Keith,

As best I can tell, Cell Validation drop-down list "Ignore blanks" does
not work, since blank lines referenced from another worksheet show up the
drop-down list.along with lines that are not blank.

I think that you misunderstand the Igmore Blanks option.

'Ignore Blanks' does not relate to a data validation list but, rather, to
the cell(s) which are being validated. Thus, for example, if the the ignore
blanks option is selected, a blank entry will be regarded as valid and no
error mesage will be shown in response to a blank entry for a validated
cell.

Is there some way to eliminate blank lines which show up as gaps in a
drop-down list?

AFAIK, only by eliminating blanks from the source list.