only want certain answers allowed to be entered in a cell

  • Thread starter Thread starter Meenie
  • Start date Start date
M

Meenie

I have Excel 2003
Is there a way to only allow certain answers to be entered in a cell?
I only want them to be able to enter either Yes, No Or N/A (case doesn't
matter).
How can I do this?
Thanks!
 
Data -> Validation -> Allow -> select List
In the list add Yes, No, NA
On the error alert tab you can specify Stop, Warning or Information.
 
Hmmm, I tried that but now it wants me to put yes, no, na in each cell, lol.
I also tried adding it as yes or no or n/a but that didn't work either.
Does it need to be in some kind of formula?
 
Ooops I figured it out :) Thanks!!

Meenie said:
Hmmm, I tried that but now it wants me to put yes, no, na in each cell, lol.
I also tried adding it as yes or no or n/a but that didn't work either.
Does it need to be in some kind of formula?
Click to expand...
 
Thank you, Jim. I had put in Yes, No, N/A but needed to account for case so
added yes, no, n/a. That made it happy :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditionally protect a cell 2
Function to determine if a cell contains a formula 5
Only allow certain numbers based on another value 2
Protect (Lock) Cell Formatting ONLY 13
Inserting a comment box in a protected worksheet 2
Excel - prevent someone from clicking into certain cells 1
Can I lock a cell after data entry so entry can not be changed 3
Filter certain cells 1

Back
Top