Select the cells H10:H11 and name the range: Berlin.

Select the cells H7:H8 and name the range: Bonn.

Select the cells G13:G14 and name the range: Manchester.

Select the cells G10:G11 and name the range: Canterbury.

Select the cells G7:G8 and name the range: London.

Select the cells F13:F14 and name the range: Eindhoven.

Select the cells F10:F11 and name the range: Rotterdam.

Select the cells F7:F8 and name the range: Amsterdam.

Select the cells H2:H4 and name the range: Germany.

Select the cells G2:G4 and name the range: Britain.

Select the cells F2:F4 and name the range: Netherlands.

Now we can start creating a name for each range. In the example, you can then choose from two streets per city. Now, we’ll create a list of streets for each city. Second, we’ll add three cities to pick from for each country. This isn’t really necessary, but it is easier to maintain to keep the cities under the right country. In this example, we create the following countries:Īs you can see I made a horizontal list instead of a vertical list. Enter the dataįirst, we’ll create the table as shown below.įirst, we’ll create a list of countries. To create conditional lists, complete the following procedures. Similarly, when you select a city in Column C, only the street names of that city will be displayed in column D. If you select Germany, only German cities will be displayed in the drop-down list in Column C. If you select Netherlands in the drop-down list in column B, only Dutch cities will be displayed in the drop-down list in Column C. In this example we’ll create the following table:Ĭolumns B, C, and D contain drop-down lists. By using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list.

In Excel 2007 (and earlier), it’s possible to create a drop-down list. Today’s author is Reinout Dorreboom from the Netherlands, a Technical Consultant at Getronics, where he has worked with Office applications for many years, and where his Microsoft Certified Training skills enabled him to help other people get up to speed with Excel.

Excel drop down list