Cell Drop Down Excel. Go to the data tab on the ribbon then click data validation. Go to the worksheet or area of your current worksheet where your list items are and then add or delete the desired item.
Copy the validation to all the cells up to cell b6. Select the cell or range of cells where you want the drop down list to appear c2 in this example. In the data validation dialogue box within the settings tab select list as validation criteria.
Create the data validation list in cells a1 a4.
On the settings tab in the allow box click list. Select the cell that contains the drop down list then in the data menu. Go to the worksheet or area of your current worksheet where your list items are and then add or delete the desired item. When we click on ok we have a drop down in cell b2.
