The drop-down list is visible at Cell E4. Put the Named Range title on the Source box. The Data Validation window will appear.Then, select Data Validation from the options.Go to the Data Tools group from the Data tab.In the Refers to field select the range for Named Range.Select Define Name group from the Formulas tab.Select the cells of the Fruit List column.New items will be added to the drop-down list by changing this Named Range. We can form a drop-down list using Named Range in Excel. Add Item to Drop-Down List by Editing a Named Range

Read More: How to Create List from Range in Excel (3 Methods)Ģ. The newly added item is shown on the list.

Now, move to Cell E4 and click on the down arrow to check the drop-down list.

Mark the option Apply these changes to all other cells with the same settings and press OK.

Now, modify the Source by selecting the range from the dataset.

Go to the Data Validation field by following the steps shown before.Add a new item at the bottom of the Fruit List column.We will add new items at the bottom of the data range by changing the source range. Now, write a Mango on Cell B9 and click on the drop-down list of Cell E4.Select Shift cells down from the Insert window.Move the cursor to any position of the Fruit List column.We will use the Insert feature to add items at any position of the selected range. Now, choose the desired range in the Source field and then press OK.Now, choose the Data Validation option.Select the Data Tools group from the Data tab.We can add items using the insert feature in the range-based drop-down list. There are two options to add items to a range-based drop-down list.ġ.1 Add Item within the Range Using Insert Feature We will show how to add items to Range based drop-down list. Add Item to Drop-Down List by Adding Item to Existing Data Range in Excel We will consider the following dataset for this purpose.ġ. Adding items will depend on how a drop-down listis created. We will apply 5 methods to add items to the drop-down list in Excel. 5 Methods to Add Item to Drop-Down List in Excel

Remove drop down menu in excel 2016