View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default Drop down boxes in Excel 2007

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.

--
Jim
"Shannon" wrote in message
...
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?