Web this is the most flexible method for adding list items in a dropdown list.

How to add plus drop down list in excel. All you need to do is follow these steps: Web on the ribbon, click data > data validation. Web in the source box, either update the cell references to include the additions or drag through the new range of cells on the sheet.

On the data tab, in the data tools group, click data validation. In an adjacent cell, insert a. On the ribbon, click the data tab, and click data validation.

In the data validation dialog. Click “ok” to apply the change. In the dialog, set allow to.

Then, customize the list using the data validation options. Select the cells you want to. Select the cells that you want to contain the lists.

Web select a cell in which you want the dropdown to appear (d3 in our case). Web everything until now works great now with all that information i would like to add the when i choose a name on the drop down menu on page pag1 also on that. This video focuses on how to use a cell range and named range.