How to Add a Drop-down to Excel 2007

By Tara Kimball

Microsoft Excel 2007 is useful for creating tracking sheets and multi-function spreadsheets for reports and data logs. If you create a spreadsheet and need to add multiple selections for a user to input, you can create drop-down lists within spreadsheet cells. Drop-down lists prevent clutter by consolidating longer lists of information within a single cell with a drop arrow instead of requiring multiple cells with various input options.

Step 1

Create a list of the data you want to appear in the drop-down box. Enter the data into a column, in the order that you want them to appear in the list.

Step 2

Click the cell where you want to insert the drop-down box. Click "Data," then select "Data Validation." Choose "Settings" in the Data Validation menu. Click "List" on the "Allow" tab. Enter the cell range for the list of data you created to appear in the menu.

Step 3

Click the checkbox next to "In-cell dropdown." Insert a checkmark in the box next to "Ignore Blank" if the field can be left blank, or clear the checkmark if you want readers to have to select an option.

Step 4

Select the "Input Message" tab and choose "Show input message when cell is selected." Enter as many as 255 characters for the message you want to appear. Save the file to store the changes.