Problem
I need to edit drop down list in excel worksheet.
Question
1. How I can edit drop down list in excel worksheet?
Solution(step by step)
Edit Drop Down List in Excel
1. Add the item to list and Select the cells of the list.
2. Click on Data tab on the top bar.
3. Click on Data Validation button on Data tools group.
4. In data validation dialog box click on settings.
5. In data validation criteria click on down arrow of allow
6. Click on List option.