How to make a drop down list in excel with 2 columns
So when you create a named range using more than one word, Excel automatically inserts an underscore in between words.
#How to make a drop down list in excel with 2 columns how to#
Read: Here is a detailed guide on how to create an Excel Drop Down List. In the above example, I have used the items in A2:A6 to create a drop-down in C3. This could be useful when you have a list of names, products, or regions that you often need to enter in a set of cells.īelow is an example of an Excel drop down list: It shows a list of items as a drop down in a cell, and the user can make a selection from the drop down. Watch Video – Creating a Dependent Drop Down List in ExcelĪn Excel drop down list is a useful feature when you’re creating data entry forms or Excel Dashboards.