Create combo box

[singkit]

how can I create combo box in excel.
for example "yes" and "no". i'd like to put them
in combo box so that i will not type them anymore in a
column just drop and down.
thanks

 

[Guest]

-----Original Message-----
how can I create combo box in excel.
for example "yes" and "no". i'd like to put them
in combo box so that i will not type them anymore in a
column just drop and down.
thanks
.
What you have to do is put Yes and No on two separate

field, then hit the combo box icon, right click the box
that appears, then double click it. Then hit a tab that
says CONTROL and where it says input range highlight the
two fields (yes and no) and hit enter. Your two results
should be available to you then

 

[Bob Greenblatt]

how can I create combo box in excel.
for example "yes" and "no". i'd like to put them
in combo box so that i will not type them anymore in a
column just drop and down.
thanks

Or, you could use data validation. Select the cells where you want this,
then go to the data menu and select validation. On the settings tab, select
List for Allow, and type "yes,no" without the quotes into the source: box.