Then, customize the list using the data validation options.

How to add plus drop down list in excel. On the ribbon, click the data tab, and click data validation. All you need to do is follow these steps: In the data validation dialog.

In an adjacent cell, insert a. On the data tab, in the data tools group, click data validation. Click “ok” to apply the change.

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

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. Start by adding a table containing your dropdown list of items. In the dialog, set allow to.

Web this is the most flexible method for adding list items in a dropdown list. 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. Select the cells that you want to contain the lists.