How do you make drop down boxs in excel

M

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?
 
K

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
 
Top