How To Edit An Excel Drop Down List. In the source box, either update the cell references to include the additions. On the ribbon, select data > data validation.
How to Edit DropDown List in Excel
On the ribbon, select data > data validation. In the source box, either update the cell references to include the additions. Click in source, type the text or numbers (separated by commas, for a comma. Go to the formulas tab, then select name manager. Web select the cells that you want to contain the lists. In the dialog box, set allow to list. Select the cells where you want to add the dropdown. Add a new item to your list, or delete the one you don't want. If you set up your list source as an excel table, then all you need to do is add or remove items from the list, and excel will automatically update any associated drop.
If you set up your list source as an excel table, then all you need to do is add or remove items from the list, and excel will automatically update any associated drop. Select the cells where you want to add the dropdown. Click in source, type the text or numbers (separated by commas, for a comma. Go to the formulas tab, then select name manager. Web select the cells that you want to contain the lists. In the dialog box, set allow to list. On the ribbon, select data > data validation. In the source box, either update the cell references to include the additions. Add a new item to your list, or delete the one you don't want. If you set up your list source as an excel table, then all you need to do is add or remove items from the list, and excel will automatically update any associated drop.
