Sep 13 2022 10:49 AM
Hi Everyone, I want to create a horizontal drop down list without any blanks
Sep 13 2022 01:25 PM
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.
Sep 13 2022 01:48 PM
Sep 13 2022 01:56 PM
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.