How to Make Drop Down Fields in Microsoft Excel

1.
Start Microsoft Excel. Open a new blank spreadsheet, or open the spreadsheet to which you want to add a drop down list.
2.
Select the cell or the range of cells in which you want to make a drop down list.
3.
Open the Data Validation dialog by going to the 'Data' menu in Excel 2003 and selecting 'Validation,' or by clicking the 'Data' tab of the ribbon in Excel 2007 and selecting 'Data Validation.'
4.
Go to the 'Settings' tab. Click the drop down arrow under 'Allow' and select 'List.'
5.
Type each list item into the 'Source' box, placing a comma between each word in the list. Click 'OK' to apply the list.