How to Create a Drop-Down Box That Can Have Multiple Selections in Excel 2007

By Cooper Temple

Typically used to track, store and calculate data, spreadsheets created using Excel 2007 may also be used as an interactive form. Forms tools, such as text fields, buttons and drop-down boxes, may be used to allow users to enter open-ended answers or select preformatted responses. When using drop-down boxes in individual cells, the response selections may be pulled from data on the current worksheet or from a separate tab in the workbook. You can create a drop-down box with multiple selections in Excel 2007 by following a few steps.

Step 1

Create the list of selections that you want listed in the drop-down box. Select a tab other than the one on which the drop-down box will appear. Type each selection in an individual cell. The cells in which the selections are listed should be sequential. For example, selections "A," "B" and "C" would be listed in cells A1, A2 and A3. A list of selections may also be created in the same tab on which the drop-down box will be created.

Step 2

Select the cell in which you want to create the drop-down box. Click the "Data" tab and locate the "Data Tools" group. Select the "Data Validation" option. This action will open a separate dialog window.

Step 3

Click the "Settings" tab on the Data Validation window. Select the "List" option from the "Allow" menu. Click the "In-Cell Drop-Down" check box.

Step 4

Click the "Source" field. Click the tab that contains the list of options you created in Step 1. Click once in the first cell of the selection string and drag to the last cell while holding down the mouse button. Click the "OK" button on the Data Validation window.