How to Make a Drop Down Menu in Office 2007 Excel
- 1). Select the cells in which you want a drop-down menu to appear.
- 2). Click the "Data" tab, then the "Data Validation" button.
- 3). Choose "List" under Validation Criteria. Check the box labeled "In-cell dropdown."
- 4). Type a list of items, separated by commas, or select cells containing the data you want to include in the drop-down list. Click "OK."
Source...