After selecting the cell where we want the main (first) conditional drop down list to appear, click on the “Data” tab, and then, “Data Validation”.
How to Create Conditional Drop Down Lists in ExcelĪ conditional drop down list in Excel makes it easier for us to input only data that meets our requirements.Ĭonditional drop downs are easy to generate and use.īelow are the steps to set-up a conditional list in Excel A conditional drop down list can be useful whenever we have a set of names, regions, or products that we regularly have to enter into a range of cells. The list displays a set of items in the form of a drop down inside a cell, and a selection can be made from the items in the drop down. The Excel conditional drop down list is a handy feature for making data entry forms.įigure 1. We can use Excel’s data validation features to generate a conditional drop down list which allows us to select a data value from a specified list. How to generate Conditional drop down list in Excel – Excelchat