Yes No dropdown box

[Pat]

how do I setup a drop down box with options to choose
from, like yes, no, NA?

 

[mike allen]

i am a novice, but i do no one way to do it. create a 'list' of options to
appear in dropdown box, say, on sheets 'list sheet' (or on same sheet) in
cells a1:c1 that contains 'yes', 'no', and 'na'.
then, select the cell(s) that you want the drop box in, hit 'data',
'validation', under 'allow' area, choose 'list' and under 'source' select
cells a1:c1 on 'list sheet'. you can then go to the next tab and type in
instructions to be shown on the box, etc.
you can also name the list and refer to it under this name like a named
range. hope this helps. mike allen

 

[gitcypher]

In an worksheet...
Create the list of values you want in your dropdown. This list can b
anywhere on your worksheet. For this example, have cells A1 through A
be "Yes", "No", and "N/A", respectively.
Select the cell where you want your dropdown.
On the Menu Bar, select DATA>>VALIDATION
In the ALLOW dropdown, select LIST
In the SOURCE field, either hit the icon to manually let you selec
your range on the sheet, or type =$A$1:$A$3
Hit OK, and your cell will have those values available in a dropdown

 

[Guest]

thanks everybody for the quick response and answers.