In the example, create a list of fruits, nuts, and vegetables.

How to create number drop down list in excel. Web how to create a dropdown list there are several ways to populate list items when you create a dropdown list within your spreadsheet. As you drag the fill handle across each cell, excel displays a preview of the value. Select the cells that you want to contain the lists.

Web select this range, then click in the name box on the left hand side of the formula bar. With the cells selected, go up to the. Let's say that the cell.

You can add or delete items from your drop. In the source box, enter the formula that indirectly refers to table1's column named items. Select a cell in which you want the dropdown.

Create the lists you need. Enter a name, for example choices, and press enter. This places the cells in a group so that you can name the group.

In the dialog, set allow to. On the ribbon, click the data tab, and click data validation. The data validation window will appear.

If you want a different pattern,.