Drop down box like a form

W

WHGRIT

I need a simple drop down box of choices of Yes, No, and N/A. How do I do
this so it acts like a form? I need it on about 100 cells. I am sure one I do
this once I can just copy and paste.
 
M

Miguel Zapico

You can use data validation, and the good thing is that you can select the
100 cells and do it at one time.
You can find it on menu Data -> Validation. In the validation criteria
select list, and
insert Yes,No,N/A in the source field.

Hope this helps,
Miguel
 
Top