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

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
"Pat" wrote in message
...
how do I setup a drop down box with options to choose
from, like yes, no, NA?

thanks everybody for the quick response and answers.
-----Original Message-----
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
"Pat" wrote in
message
...
how do I setup a drop down box with options to choose
from, like yes, no, NA?


.

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 DATAVALIDATION
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

--
Message posted from http://www.ExcelForum.com