| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
only want certain answers allowed to be entered in a cell
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only want certain answers allowed to be entered in a cell
Data - Validation - Allow - select List
In the list add Yes, No, NA On the error alert tab you can specify Stop, Warning or Information. -- HTH... Jim Thomlinson "Meenie" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only want certain answers allowed to be entered in a cell
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? "Jim Thomlinson" wrote: Data - Validation - Allow - select List In the list add Yes, No, NA On the error alert tab you can specify Stop, Warning or Information. -- HTH... Jim Thomlinson "Meenie" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only want certain answers allowed to be entered in a cell
Did you put in the commas? Comma is the delimiter.
-- HTH... Jim Thomlinson "Meenie" wrote: 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? "Jim Thomlinson" wrote: Data - Validation - Allow - select List In the list add Yes, No, NA On the error alert tab you can specify Stop, Warning or Information. -- HTH... Jim Thomlinson "Meenie" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only want certain answers allowed to be entered in a cell
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 :) "Jim Thomlinson" wrote: Did you put in the commas? Comma is the delimiter. -- HTH... Jim Thomlinson "Meenie" wrote: 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? "Jim Thomlinson" wrote: Data - Validation - Allow - select List In the list add Yes, No, NA On the error alert tab you can specify Stop, Warning or Information. -- HTH... Jim Thomlinson "Meenie" wrote: 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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only want certain answers allowed to be entered in a cell
Ooops I figured it out :) Thanks!!
"Meenie" wrote: 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? "Jim Thomlinson" wrote: Data - Validation - Allow - select List In the list add Yes, No, NA On the error alert tab you can specify Stop, Warning or Information. -- HTH... Jim Thomlinson "Meenie" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set a maximum of characters allowed in a cell | Excel Discussion (Misc queries) | |||
| how many character are allowed in a cell | Excel Discussion (Misc queries) | |||
| how many if statements are allowed per cell? | Excel Worksheet Functions | |||
| a way to limit the characters allowed in a cell? | Excel Worksheet Functions | |||
| Format spreadsheet so no input allowed if certain cell is =<0 | Excel Worksheet Functions | |||
Hybrid Mode
