Remove drop down menu in excel 2016
With this data table, we have to make a dependent drop-down list in Cell C17. They have not been classified into two different lists. In the following picture, you’re seeing the smartphone models of two brands together in a column. Now we’re going to work with a modified data table. Make a Conditional Drop Down List with Unorganized Data Table
Remove drop down menu in excel 2016 how to#
Read more: How to Create Dynamic Dependent Drop Down List in ExcelĢ. Now select a smartphone brand from the independent drop-down in Cell C13 and then click on the dependent drop-down button in Cell C14, you’ll find all the smartphone models of the selected brand.Īlter the smartphone brand and you’ll find the corresponding smartphone models only, as shown in the screenshot below. The function will store the smartphone models in arrays for two different brands. ➤ In the Source box, type the following formula:īy using the INDIRECT function here, we’ve mentioned the cell reference of C13. ➤ Open the Data Validation dialogue box again. ➤ Since we have to create a dependent drop-down list in Cell C14 now, select the mentioned cell first. So, we’ve just created two named ranges for two different smartphone brands with their corresponding models.
![remove drop down menu in excel 2016 remove drop down menu in excel 2016](https://helpdeskgeek.com/wp-content/pictures/2019/01/excel-figure-1-1.png)
➤ 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.
![remove drop down menu in excel 2016 remove drop down menu in excel 2016](https://cdn.educba.com/academy/wp-content/uploads/2019/01/Remove-Spaces-Example-2-3-420x299.png)
➤ 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. In our first criterion, we’ll make a dependent drop-down list from some organized data.
![remove drop down menu in excel 2016 remove drop down menu in excel 2016](https://www.passfab.com/images/topics/excel/unprotect-excel-2016.jpg)
Create a Conditional Drop Down List with Classified Data Table 4 Ways to Create Conditional Drop Down List in Excel 1.