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

@IS_MA1845 

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

image.png

Same on Excel for web

image.png

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

Hello sergei i have 2021 version

@IS_MA1845 

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.