Web on the ribbon, click data > data validation.

How to add drop down list in new excel. This will open the code window for that. On the first sheet, select cell b1. On the data tab, in the data tools group, click data validation.

Select the data tools group from the data tab. Web select and copy the source list range in the source workbook. Back on the first sheet, select the blank cell to the.

Web you aim to add a dropdown list where each item appears just once. In the data validation dialog. To extract the unique items, use this formula:

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. Please note that there’s more than one way to create a d. Web select a cell in which you want the dropdown to appear (d3 in our case).

Enter a name, for example choices, and press enter. Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ). To specify the values that you want to use as the entries in the.

Select the cells where you want to add the dropdown. In the source box, add new list. Web set up your first drop down list.