How Do I Create Drop-Down Boxes in Excel?

When you're creating an Excel spreadsheet that collects data, you might want to insert a drop-down box. This is useful in focusing response options, as it contains a list of predetermined values, restricting the user from entering any information other than the values included in the list. To create a drop-down box, you must create a list of values and insert the values using Excel's Data Validation.

Step

Create a list of values that you want included in your drop-down box. It cannot contain any blank cells and must be created in a single column or row.

Step

Sort the values according to the order that you want the information to appear in the drop-down box.

Step

Click the cell in which you want the drop-down box to appear.

Step

Click the "Data" tab and click "Data Validation" in the "Data Tools" group. Click the "Settings" tab.

Step

Click the arrow next to the drop-down box in the "Allow" section and click "List."

Step

Check the "In-cell Dropdown" box.

Step

Check the "Ignore Blank" if you do not want to require the user to select an entry.

Step

Click the arrow after the "Source" field and select the list of values from your Excel spreadsheet. Press "Enter."

Step

Click the "OK" button and click the arrow next to your drop-down box to verify the data.