software

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.

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 -gt; Validation. In the validation criteria
select list, and
insert Yes,No,N/A in the source field.

Hope this helps,
Miguel

quot;WHGRITquot; wrote:

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

Take a look at Data=gt;Validation.

quot;WHGRITquot; wrote:

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