Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

You can put them in as a comma separated list:

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

etc.

share|improve this answer
add comment

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

share|improve this answer
    
Guess I was over thinking this. –  KronoS Jul 12 '12 at 17:02
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.