Excel drop down list: create, edit, remove and more advanced...
2) Make sure theIn-cell dropdownbox is checked. If this box is unchecked, the drop-down arrow won’t appear when selecting cell. 3) In theSourcebox, you can manually type in comma-separated values as the below screenshot shown.