Create a manual data validation list in Excel

Question

I want to make a very simple manual dropdown list in a cell with the values Yes or No.

I do not want to select a range of possibilities for only 2 options. So I want to enter the possible values manually.

It is my understanding according to these articles (link1, link2), that I can do so by going to a cell, going to data > data validation. Select List from the allow dropdown and then in the source field enter my dropdown entries manually (comma seperated).

However, if I do so, I get this:

So, I get only 1 option Yes,No instead of 2 options with Yes or No. What am I doing wrong? I tried seperating them with a comma and a space aswell. Didn't work.

Thomas C. · Accepted Answer · 2022-08-31 09:42:21Z

1

In source, write this Yes;No instead of Yes,No

answered Aug 31, 2022 at 9:42

Thomas C.

2171 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Reinier68 Over a year ago

Cheers. Did this change then? Because those articles clearly state that I should seperate the values with a comma.

Thomas C. Over a year ago

Idk to be honest, are you usually using , or ; in formulas ? Depending on region some use , instead of ;

Reinier68 Over a year ago

That might explain things. I don't use formulas that often. Well, thank you anyway.

user20613441 · Accepted Answer · 2022-11-27 10:20:52Z

0

first:

Control panel--> Region-->Formats Tab-->Additional settings--> Numbers Tab-->List separator value change to: ,(comma) then ok.ok

answered Nov 27, 2022 at 10:20

user20613441

1

Collectives™ on Stack Overflow

Create a manual data validation list in Excel

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related