Forum Discussion
Vacant line in drop down list
I am trying to build a drop-down list from a range of cells: D5:J5 D5:F5 are Merged G5:I5 are Merged J5:L5 are Merged Using the following: My Drop-down is showing a gap b...
What am I doing wrong?
you are using merged cells! Don't.
But now why it happens. The data validation list includes all values it finds in the range D5:J5 but eliminates duplicates. So that's a first text, an empty field, a second text and a third text. The empty fields come from columns E, F, H and I.