How To Change Drop Down Options In Excel. Go to data > data validation. Ideally, you’ll have your list items in an excel.
How to Edit DropDown List in Excel
Edit drop down menu based on a range of cells. Ideally, you’ll have your list items in an excel. On the settings tab, click in the source box, and then change your list items as needed. Go to data > data validation. On the data tab, in the data. 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.
Ideally, you’ll have your list items in an excel. Edit drop down menu based on a range of cells. On the settings tab, click in the source box, and then change your list items as needed. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired. Go to data > data validation. Ideally, you’ll have your list items in an excel. In the source box, either update the cell references to include the additions. On the data tab, in the data.
