How to apply Conditional Formatting in drop down list? In this way, we can create drop down list or pick list in Microsoft Excel by using Data Validation option.įind out some more Data Validation articles:.

Click on the button, you will get student list, from where you can pick any name from the list.

Now you will see the button in the cell, this is drop down list.

Select List (allow drop down list) > Enter range name (student_list).

Select the cell where you want to insert drop down list.

Open the file that contains the source list (Source.xlsx in this example) and create a name range for the entries you want to include in your drop down list, e.g.

We have students name list, we will create drop down list for student name list.įirst we will create a name range. To create drop down list, let’s take an example to understand: To do this, you need to create 2 name ranges one in the source file and another in the Main file where you want to use the Data Validation list. You can make a drop down menu in Excel, using a list from another workbook as the source. The drop down list will be helpful for the end user to select the item from the drop down list rather than typing in Excel. While working on reports, you can make reports more secure so that no one can intentionally or unintentionally make any changes to your drop down lists.

In this article, you will learn how to make Excel drop down list from another workbook.

Create a drop down list in excel