How do you make drop down boxs in excel

[Mai]

I need to make several drop down boxs in my worksheet, but
don't know how, can anyone give me direction on how to do
this?

 

[Ron de Bruin]

See Debra's site first and post back if you need something else
http://www.contextures.com/xlDataVal01.html

 

[Kathy]

Select View
Tool Bars
Select Forms toolbar
From new tool bar select "list box" option
Put cursor on area and drag to desired size
Right click mouse

Select Format Control
Within format control select Control tab
Input cell references that contain text you want listed