Tag: make the dropdown list in excel

STEPS : Prepare the list for drop-down in Excel sheet.Select the cell or range where you want to create a drop-down.Go to View tab.Click on Data Validation.In the Data Validation dialogue box, . Choose “List” from Allow drop-down.Type or Select the range of source data in source box.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. Select Cell or Range, who has drop-down that you want to Delete.Go to view tab.Click on Data Validation.In the Data Validation dialogue box, Click on Clear All.Click OK. See the Result in Image below.