Drop down boxes in Excel 2007

S

Shannon

Can anyone tell me how to create a drop down box in Excel 2007, which would
allow me to select from a variety of choices?
 
J

Jim Rech

Try Data Validation on the Data tab. Select the "List" option. Have a list
of the items you want to appear in the drop down already entered somewhere.
 

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

How to delete a drop down box in Excel 2007 1
Excel Drop Down Box 2
Drop Down Lists 2
drop down menu for excel 2007 3
how to delete drop down boxes 2
Multi layered drop down 1
drop down box 1
Expanded Drop Down Box Question 2

Top