➤ Put a mark on the first option ‘Top row’ only and leave other options unmarked. ➤ Under the Formulas ribbon, choose the Custom from Selection command from the Defined Names drop-down. ➤ Now select the entire table or the range of cells B4:C11. So, we’ve just created an independent drop-down list for the smartphone brands in Cell C13. ➤ Activate editing in the Source box and select the range of cells (B4:C4) containing the brand names of the smartphones. ➤ In the Allow box, select List from the options. ➤ Under the Data tab, choose the Data Validation command from the Data Tools drop-down. After that, we’ll make a dependent drop-down list in Cell C14 where smartphone models will be shown in a list based on the selected brand from the previous drop-down list. In Cell C13, we’ll create an independent drop-down list for the brand types. In the picture below, you’re now seeing two columns containing smartphone models of two different renowned brands. Now we’ll make a dependent drop-down list and this category is mostly used in practical approaches. Create a Dependent Drop Down List in Excel Now you can select any smartphone model and use it later as any other input data in a formula.Ģ. ➤ Click on the drop-down button in Cell E7, you’ll find the list of Samsung smartphones that are present in the table. ➤ Click on the Source box and select the range of cells (B5:B11) containing the model names of the smartphones. ➤ In the Allow box, choose List from the options. ➤ Under the Data ribbon, select the Data Validation command from the Data Tools drop-down. Now we’ll make a drop-down list in Cell E7 from where you can select any smartphone model listed in the chart. In the following picture, you’re seeing a list of popular Samsung smartphones. Create an Independent Drop Down List in Excel Follow the steps carefully and you’ll find them convenient to apply in your Excel spreadsheets. We can start with an Independent Drop Down list first. But the values in the Dependent Drop Down list are connected to a particular criterion or a named range. In the Independent Drop Down list, the values are not assigned to any other criteria. There are two types of drop-down lists in Microsoft Excel: Independent and Dependent.
Microsoft excel drop down lists how to#
How to Make Two Types of Drop Down List in Excel
0 kommentar(er)
