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