Editing A Drop Down List In Excel. On the data tab, in the data. In the source box, either update the cell references to include the additions.
How to Edit DropDown List in Excel
To remove an item, press delete. Go to the data tab on the ribbon, and then data validation. If the item you want to delete is somewhere in the middle of. If you can’t select data validation, the worksheet might be protected or shared. In the source box, either update the cell references to include the additions. On the data tab, in the data. Edit drop down menu based on a range of cells.
In the source box, either update the cell references to include the additions. On the data tab, in the data. Go to the data tab on the ribbon, and then data validation. In the source box, either update the cell references to include the additions. If you can’t select data validation, the worksheet might be protected or shared. If the item you want to delete is somewhere in the middle of. To remove an item, press delete. Edit drop down menu based on a range of cells.
