Help ! Horizontal Drop Down List Without Blanks Excel

New Contributor

Hi Everyone, I want to create a horizontal drop down list without any blanks

Horizontal drop down list.png



3 Replies


Latest desktop Excel removes blank cells automatically. Perhaps still for insiders, not sure.


Same on Excel for web


On previous version if create helper range without blanks. Again depends on version.

Hello sergei i have 2021 version


I don't think 2021 will be updated with new functionality, but who knows.

In it you may generate helper range at any place of your workbook, like

=FILTER(A2:H2, A2:H2<>"")

and create data validation list referencing it.