drop down list

Copper Contributor

i have an excel and i want to create a drop down menu. if to do it by adding the data of the drop down in different cells and set as source it works. if go to data -->data validation --> list -->check the two options and add on source the data manually separated by comma. the outcome is that get a drop down with one option which the data separated by commas and not the one below the other.

ichatz77_0-1593717828627.png

 

1 Reply

@ichatz77 Can you screenshot your Data validation? Since I just choose List and put in Source field yes, no and it works fine with each option is a separate line.

Dropdown.png