yes or no option

C

Chief Quinn

How do I create a field in excel that only provides a user a yes or no option?
 
P

Paul B

Chief, have a look at data, validation
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
P

peterm

Example - Go to Z1 type in Answer(in bold) go to Z2 type in Yes go to Z3 type
No
Highlight Z2 & Z3 go to drop down box at top near = sign (should read Z2
type in Answer hit enter Go to cell you want the drop down list. then data >
validation change to list in source put = Answer. You can do this to a whole
columns or a group of cells
Cheers
peterm
 
Top