Question

How to create drop down list in excel 2007?

Answer 1

11 steps:
Open the spreadsheet in which you want to add the drop-down box

Create a list of the items to appear in the drop-down list. 

Click the cell you want to place the drop-down box in.

Click the "Data" tab of the Microsoft Excel 2007 ribbon.

Click the "Data Validation" button from the "Data Tools"

Click the "Settings" tab and then click "List" from the "Allow" drop-down list box.

Click the toggle button at the end of the "Source" box

Select or clear the "Ignore blank" check box, depending on whether you allow the cell containing the drop-down box to be left blank

Click the "Input Message" tab to display a message box when the cell of the drop-down box is clicked

Click the "Error Alert" tab to display an error message if invalid data is entered into the drop-down box cell.

Click "OK" to save the validation criteria and create the drop-down box.