[header] How to add a drop down box in excel 2007 [title] Open the spreadsheet in which you want to add the drop-down box (es). [title] Create a list of the items to appear in the drop-down list. [step] Type the data in the order it will be displayed in the list. 
The entries should be typed in a single column or row and should not contain any blank cells. [substeps] To create the list of the desired items on a separate worksheet, click the tab of the worksheet in which to enter the data.