How to Add a Drop Down Box in Excel 2007


Adding a drop-down box to your Excel 2007 spreadsheet can speed up data entry by offering users a list of items to select from instead of having to type information each time. When you put a drop-down box in a spreadsheet cell, the cell displays an arrow. You enter data by clicking the arrow and then selecting the desired entry. You can set up a drop down box in just a few minutes, and greatly improve your data entry speeds.

Part 1

 on How to Add a Drop Down Box in Excel 2007

1

 on How to Add a Drop Down Box in Excel 2007

2
Type the data in the order it will be displayed in the list. The entries should be typed in a single column or row and should not contain any blank cells. To create the list of the desired items on a separate worksheet, click the tab of the worksheet in which to enter the data. Type and then highlight the data to appear in the list. Right-click the highlighted range of cells and click "Name a Range" from the list that appears. Type the name for the range in the "Name" box and click "OK." You can then protect or hide the worksheet to prevent other users from making changes to the list.

 on How to Add a Drop Down Box in Excel 2007

3

 on How to Add a Drop Down Box in Excel 2007

4

 on How to Add a Drop Down Box in Excel 2007

5
The "Data Validation" dialog box appears.

 on How to Add a Drop Down Box in Excel 2007

6

 on How to Add a Drop Down Box in Excel 2007

7
Select the list of items you want to have in your drop-down box. If you created a range name, in the "Source" box, type an equal sign and then type the name of the range.

 on How to Add a Drop Down Box in Excel 2007

8
Make certain the "In-cell dropdown" check box is selected.

 on How to Add a Drop Down Box in Excel 2007

9
Make certain that the "Show input message when cell is selected" check box is selected and then type the "Title:" and "Input message:" that will appear in the message box.

 on How to Add a Drop Down Box in Excel 2007

10
Make certain that the "Show error alert after invalid data is entered" check box is selected. To display a warning or information but not prevent invalid data from being entered, select either "Warning" or "Information" from the "Style" drop-down list box. To display a message and prevent invalid data from being entered, select "Stop" from the "Style" drop-down list box. Type the "Title:" and "Error message:" that you want to appear.

 on How to Add a Drop Down Box in Excel 2007

11