How to Insert Drop Down Boxes in Cells in Microsoft Excel 2007

Microsoft Excel 2007 offers a variety of data entry options, one of which is the ability to input data via a drop-down box inserted directly in the spreadsheet. With assistance from the Data Validation tool, a user can create a list of predetermined entries or options and choose which cell the drop-down box will be active in, allowing an easier way to input recurring data throughout the spreadsheet.

...
Insert drop-down boxes in Excel 2007 to simplify data entry.

Step

Open Microsoft Excel 2007.

Step

Type the data or names that you want to appear in the drop-down list in an empty column. You can choose any column as long as you don't use it for your other data.

Step

Click the "Data" menu tab and click "Data Validation" from the list of options available.

Step

Click the 'Settings" tab and select "List" from the drop-down box titled "Allow." In the "Source" box, type the cell range (i.e., A1:A5) for where the list appears or click the button to the right of the box and select the cells with your mouse.

Step

Click the check box to select "In-cell dropdown." Click "OK" once you have finished. An arrow appears next to the cell you originally chose, allowing you to input data from a list of choices.