So when the first category is fruit than amongst the elements of the second list we will not see for example the pepper, only the fruits.
In the second list only those elements will appear that are dependent on the first list. The first list contains two categories, these are the vegetable and fruit. We would like to classify all the elements into two categories. We have 20 kinds of different vegetables and 20 different fruits. This means that there are two drop-down menus, and the elements appearing in the second one depending on the choices we made in the first one. How can the list be a two-level dependent list? It might happen that we need a solution that the simple list is not able to solve. Nonetheless don’t need to be afraid of the task! With the help of our step-by-step tutorial we will expound in minutes what is it all about! Prepare the worksheet in seconds!ġ: First of all we have to create a sheet with all the names of our products for the further calculations.
This will be a little more complicated task. In the second part we will introduce the dependent (conditional) drop-down list. In the first tutorial we will show in detail the creation of a drop-down list. Just think about all the mistakes and errors we can avoid with the help of this method! There is no mistakenly entered name anymore, the specified list will not allow incorrect data entry. The drop-down list can be imagined like a little menu from where we can only chose the value that was previously specified. Its main function is the limitation of data input, in a given cell we can only chose the elements of one fixed list. Can be used almost all of the making of interactive dashboard templates in Excel. The Excel drop-down list is a great tool that belongs to the data validation group.