S Shannon May 2, 2008 #1 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?
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 May 3, 2008 #2 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.
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.