In the dialog, set allow to.

How to add plus drop down list in excel. 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. In an adjacent cell, insert a. Click “ok” to apply the change.

Web on the ribbon, click data > data validation. Select the cells that you want to contain the lists. All you need to do is follow these steps:

Web select a cell in which you want the dropdown to appear (d3 in our case). On the ribbon, click the data tab, and click data validation. Start by adding a table containing your dropdown list of items.

In the data validation dialog. This video focuses on how to use a cell range and named range. Select the data tools group from the data tab.

Select the cells you want to. Then, customize the list using the data validation options. On the data tab, in the data tools group, click data validation.