Remove Drop Down List In Excel 2016 For. If you have multiple cells with drop-down lists that you want to delete you. In the Source box specify the range that contains the drop-down list items in this example the range is E1E8.

When you create a d. Edit a drop-down list thats based on a named range Edit a drop-down list thats based on a range of cells. Once the drop down menu is open there are a lot of keyboard shortcuts that apply to this menu.
Try out your drop-down list.
In the Source box specify the range that contains the drop-down list items in this example the range is E1E8. Hide or Unhide Columns based on Drop-down List Box Step1. In the Allow drop-down list select the List item. Otherwise Excel validates your data entry but does not show the drop-down button to select items from the list.