checkbox and drop-down list

N

Nydia

I want to create a form using excel. i tried dragging a
check box into a field and it shows a check box, but it
does not allow you to check it. How can I get a check box
to work in excel?

Also, how would i get a drop down list to work in excel??
 
J

Jim

Do want want an in-cell dropdown? Data>Validation>Allow>List.
Enter =MyList where you have your list in a range of cells named MyList
OR
=A2:A100 where you list in in that range
OR list you options in the window, each separated by a column with no spaces
between.
 
Top