And then, insert the vba code at.

How to add drop down list in excel for entire column. Click on the data validationbutton in the data toolsgroup. Get items for the main drop down list for starters, we shall extract all different. You can add or delete items from your drop.

Go to the data tab in the ribbon. Edit, copy, delete, add or remove items without changing the data. Web select the topmost cell in which you want the primary dropdown list to appear (b3 in our case).

First, you make a regular data validation list in one or more cells. Web select the cell for your dropdown list. Web on the ribbon, click data > data validation.

Image is no longer available. In the data validation dialogue. On the data tab, in the data tools group, click data validation.

This will open up the data.