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