Easy way to Learn dropdown in EXCEL 2007 - Tutorial - Case Study

Open the Excel, Rename Sheet1 as List and enter the name as below

Click Formulas -> Define Name

Give the name as “NameList” and select the Range from A2 till A15 in List Sheet. It will show the below screen

Click OK

Now, Open Sheet2 and enter the data as shown below:

Now, highlight B2 to B4.  Click Data -> Data Validation -> Data Validation as below:

It will display the below screen. Select List from Dropdown. Type =Namelist as below

Click OK

From now, you will be able to select the Names as dropdown box in B2, B3, B4 cell as below

Done.