Web here is how you can directly enter it in the data validation source field:
How to create a drop down list in excel without blanks. On the data tab, in the data tools group, click data validation. Web feb 23, 2023, 11:00 am edt | 3 min read. In this article, i will discuss how you can create.
Select a cell where you want to create the drop down list (cell c2 in this example).