Combo Box Considering Empty Cell as well, but the cells are Merged to the first Cell

[Dheepak]

Hi,

When i make the merged cells and i selected to have them as the values under Combo box, its considering the empty cells as well.

I have merged the cells A12 to A15 as Product A and i merged the cells A16 & A17 and named as Product B. After inserting the combo box from developer tab (Form Controls), if i select those two merged cells, the range under format control displays $A$12:$A$17. Perhaps, this includes 6 Value under the combo box along with 4 blank option and remaining two as Product A and Product B.

But, I need only the content from A12 and A16 not other empty cells.. Any solution available for this?

I have tried Data Validation Option as well and the result was same as the form control combo box function.

Thanks in advance!!!

Best Regards,
Dheepak