How To Edit Dropdown In Excel. On the data tab, in the data tools group, click data validation. In the source box, either update the cell references to include the additions.
How to Edit DropDown List in Excel
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. In the source box, either update the cell references to include the additions. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item. On the data tab, in the data tools group, click data validation. Select the cell that contains the drop.
Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item. Select the cell that contains the drop. On the data tab, in the data tools group, click data validation. In the source box, either update the cell references to include the additions. 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. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.
