Make sure the items are consecutive (no blank rows).

How to add drop down checklist in excel. Or select a range of cells on the sheet containing the. Web select a cell in which you want the dropdown to appear (d3 in our case). Web in the allow box, select list.

To remove an item, press delete. Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ). In the source box, add new list.

In the data validation dialog. Web select one or more cells for your dropdown (d3:d7 in our case). On the data tab, in the data tools group, click data validation.

On the data tab, in the data tools group, click data validation. Web here are the steps to create an excel drop down list: Select a cell where you want to create the drop down list.

Optionally, you can check the box to ignore blank cells if you like.