checkbox and drop-down list

  • Thread starter Thread starter Nydia
  • Start date Start date
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??
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Drop Down List - Different Tab 1
Drop Down List Location Question 3
Change states of some checkboxes from drop-down list? 5
How to delete a drop down box in Excel 2007 1
Excel Drop Down Box 2
Drop down list 1
Max number of drop-down list elements in excel 3

Back
Top