In this article, you will learn how to make Excel drop down list from another workbook. 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.
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.
You can make a drop down menu in Excel, using a list from another workbook as the source. 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.
How to insert drop down list in Excel?
To create drop down list, let’s take an example to understand:
We have students name list, we will create drop down list for student name list.
First we will create a name range. Follow below given steps:
In this way, we can create drop down list or pick list in Microsoft Excel by using Data Validation option.
Find out some more Data Validation articles:-
How to edit a drop down list in Excel?
How to apply Conditional Formatting in drop down list?
How to create dependent drop down list?
How to create multiple dropdown List without repetition using named ranges?
Click on the video link for quick reference to the use of Data Validation. Subscribe to our new channel and keep learning with us!
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
