How do you create a drop down list in Excel 2007?

Answer 1

If it is a form control, the right click on it and select it. Then press the delete key.

In 2007 select the formulas tab, select "name Manager". A list will display. Select the item to remove and then select delete. All reference is gone.

For ones created by using the Data Validation option, on the top menu click "Data" and find "Data Validation" which will open a dialog box with the dropdown settings. Find the "Clear All" button and click it.

This procedure can be followed if the dropdown list is added using the "Data Validation" process.

Answer 2

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

The control to create a drop down list in Excel is called a Combo Box.

Answer 3

Use the Data Validation tool.

For Excel 2007:

1. In a column, make a list of the items you want in the drop-down box.
2. Give the list range a name or just identify the range (e.g. A1:A23).
3. Click on the cell or range where you would like to make the drop-down box.
4. From the Data tab on the ribbon bar, in the Data Tools section, select Data Validation.
5. From the Data Validation window, on the Settings tab observe Validation criteria section.
6. In the Allow: dropdown, select list. You will observe a new field for Source.
7. In the Source: box, enter your list range by whatever method you like (e.g. =A1:A23).
8. If you like, you can make entries on the Input Message and Error Alert tabs.
9. Click OK.
10. Observe in the drop-down arrowhead in the cell or range you highlighted, the list you identified.

Answer 4

1. Create a list you want to include in the drop-down box.
2. Give the list a name (e.g. listname).
3. Go to the cell where you would like to include the list and click the Data Validation link (in Excel 2007, on the Data Tab, in the Data Tools section).
4. In the Data Validation window, select List from the Allow: options.
5. In the Source window, enter =listname. If you did not give your list a name, then enter the range (e.g. =D12:D30).
6. If you like, you can complete the options for Input Message and Error Alert.
7. Click OK and view your drop-down box creation.
8. If you like, you also could add a comment to the cell telling the user to select an option from the list.

Answer 5

The control to create a drop down list in Excel is called a Combo Box.

Answer 6

You want to use a process using dependent data validation lists. See related links for a couple of different ways to accomplish this task.