drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-1503266%22%20slang%3D%22en-US%22%3Edrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503266%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20an%20excel%20and%20i%20want%20to%20create%20a%20drop%20down%20menu.%20if%20to%20do%20it%20by%20adding%20the%20data%20of%20the%20drop%20down%20in%20different%20cells%20and%20set%20as%20source%20it%20works.%20if%20go%20to%20data%20--%26gt%3Bdata%20validation%20--%26gt%3B%20list%20--%26gt%3Bcheck%20the%20two%20options%20and%20add%20on%20source%20the%20data%20manually%20separated%20by%20comma.%20the%20outcome%20is%20that%20get%20a%20drop%20down%20with%20one%20option%20which%20the%20data%20separated%20by%20commas%20and%20not%20the%20one%20below%20the%20other.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ichatz77_0-1593717828627.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202946i5FB2BB2657AA0136%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ichatz77_0-1593717828627.png%22%20alt%3D%22ichatz77_0-1593717828627.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503266%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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
Highlighted

@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