![]() These are called dependent drop-down lists in Excel.īelow is an example of what I mean by a dependent drop-down list in Excel: Sometimes, however, you may want to use more than one drop-down list in Excel such that the items available in a second drop-down list are dependent on the selection made in the first drop-down list. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |