Select the data tools group from the data tab.

How do i add a drop down list to a drop down list in excel. In the source box, enter the formula that indirectly refers to table1's column named items. The cleanest way to set something like this up is to create a new tab in excel where you can configure all of. The data validation excel window opens up.

On the first sheet, select cell b1. Web hello to everyone guys i would like to add the following to my excel i have a page called vendedores with the following table: Select the cells that you want to contain the lists.

Enter a name, for example choices, and press enter. Web in the data tools section of the data tab, click the “data validation” button. On the ribbon, click the data tab, and click data validation.

Make sure the items are consecutive (no blank rows). Go to the data tab, and under the data tools, click on data validation. On the data tab, in the data tools group, click data validation.

In the source box, either update. In the data validation dialog. On the second sheet, create the following named ranges.

The data validation dialog box displays. A useful feature in excel is the ability to create a dropdown list from the data directly above the current. ( on this table i have all the.