How do I create a data validation list WITHOUT using cells?

7

I have a simple data validation dropdown that I'm trying to do, but I DO NOT WANT to use cells to populate my list.

Something similar to what's below, but this obviously isn't working.

enter image description here

What formula do I need to input to create a list of strings in a cell?

James Mertz

Posted 2012-07-11T23:46:08.570

Reputation: 24 787

Answers

10

Unless you mean something else, no need to wrap in quotes, or use the "=" sign enter image description here

datatoo

Posted 2012-07-11T23:46:08.570

Reputation: 3 162

5

You can put them in as a comma separated list:

true,false
yes,no
2,4,6,8
with space,without

etc.

Mike Fitzpatrick

Posted 2012-07-11T23:46:08.570

Reputation: 15 062

0

So for anyone who might have run into this problem, I found the solution (or rather the cause).

I had previously tinkered with the locale parameters of my system and altered the list separator character to semicolon in Control Panel > Clock & Region > Region > Additional Settings. When I used that instead of comma, the dropdown worked. The question is now whether this will continue to work on a system with the standard separator.

Ehsan Amini

Posted 2012-07-11T23:46:08.570

Reputation: 1