Forum Discussion
Help ! Horizontal Drop Down List Without Blanks Excel
Hi Everyone, I want to create a horizontal drop down list without any blanks
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.