Create drop down List in Excel.

STEPS :

1. Prepare the list for drop-down in Excel sheet.
2. Select the cell or range where you want to create a drop-down.
3. Go to View tab.
4. Click on Data Validation.
5. In the Data Validation dialogue box, . Choose “List” from Allow drop-down.
6. Type or Select the range of source data in source box.
7. Click OK

Note- you can create a drop-down in same sheet or in other sheet and can pass the referecne according to the requirement.

See the Result in Below Image.

Remove/Delete Drop-Down in excel.

1. Select Cell or Range, who has drop-down that you want to Delete.
2. Go to view tab.
3. Click on Data Validation.
4. In the Data Validation dialogue box, Click on Clear All.
5. Click OK.

See the Result in Image below.