For example, if you have.

How to add data to drop down list in excel. The steps slightly vary depending on whether the source items are in a regular range,. Let's say that the cell. On the first sheet, select cell b1.

This article explains how to create a drop. On the second sheet, create the following named ranges. Select data validation to open the data validation dialog box.

In source, type =my list name. Now, i can either type the name or i can choose the name. Select the data tools group from the data tab.

Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ). Web click data > data validation (drop down) > data validation… the data validation dialog box opens. In the source box, add new list.

Select a cell, then select data > data validation. I'll click in the source. On the settings tab, select list from the allow box, and enter.

The data validation window will appear. Web select this range, then click in the name box on the left hand side of the formula bar. Web to insert a drop down list in excel, you use the data validation feature.