forbee.blogg.se

In the popped out Create Names from Selection dialog box, check only Top row option, see screenshot:ĥ. And then, select the second drop down list data and then click Formulas > Create from Selection, see screenshot:Ĥ. Then, select the first drop down list values (excluding the header cell), and then give a range name for them in the Name box which besides the formula bar, see screenshot:ģ. Secondly, create range names for each drop down list values.Ģ. First, create the first, second and third drop down list data as below screenshot shown: To create a multi-level dependent drop down list, please do with the following steps:įirstly, create the data for the multi-level dependent drop down list.ġ. In Excel, you may create a dependent drop down list quickly and easily, but, have you ever tried to create multi-level dependent drop down list as following screenshot shown? This article, I will talk about how to create a multi-level dependent drop down list in Excel.Ĭreate multi-level dependent drop down list in ExcelĬreate multi-level dependent drop down list in Excel with an amazing feature