How to Create a Dropdown List in Excel 2007

1. Type a list of entries for the drop-down list in a single column. For example, if you want a drop-down list for the days of the week, type 'Monday' in cell A1, 'Tuesday' in cell A2, 'Wednesday' in cell A3, 'Thursday' in cell A4, 'Friday' in cell A5, 'Saturday' in cell A6, and 'Sunday' in cell A7.
2. Click on the cell where the drop-down list will go.
3. Click on the 'Data' tab, then click on 'Data Validation,' then click on 'Data Validation' again.
4. Click on the 'Settings' tab in the dialog box.
5. Click on 'List' from the 'Allow' box.
6. Enter the cell references into the 'Source' text box. In the above example, you would type '=A1:A7.' The 'in-cell dropdown' check box should already be checked. If it isn't, make sure to check it.
7. Click on the 'OK' button. Excel will insert a list into the chosen location.