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 between Action 1 and Action 2.
What am I doing wrong?
Thanks
- That did it.
Thanks 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.
