yes or no option

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a field in excel that only provides a user a yes or no option?
 
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
 
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
 
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

Simple Yes/No drop down box 2
How to create yes/ no box for selection? 6
Prefilled Outlook Yes Voting Button response 0
Access how do you set a yes/no data type as required? 0
How to create a group combo box (Yes/No)? 16
How do I create an option button? 2
Option box question 1
Formula to answer YES or No 4

Back
Top