create drop down list

Dropdown lists can be created in Excel to allow a user to select from a list of items during data entry. Creating a dropdown list in Excel is quite simple.…