Create the lists you need.

How to create number drop down list in excel. This places the cells in a group so that you can name the group. Web list the items for the dependent list, and then select the cells. With the cells selected, go up to the.

Enter a name, for example choices, and press enter. Select a cell in which you want the dropdown. In the example, create a list of fruits, nuts, and vegetables.

In the source box, enter the formula that indirectly refers to table1's column named items. Let's say that the cell. As you drag the fill handle across each cell, excel displays a preview of the value.

Web select this range, then click in the name box on the left hand side of the formula bar. Web drag the fill handle across the range that you want to fill. On the ribbon, click the data tab, and click data validation.

Web this section describes how to set up the dependent dropdown lists shown in the example. The data validation window will appear. If you want a different pattern,.

In the dialog, set allow to.