How do you change drop down in Excel?
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-down list, then, in the Data menu at the top of your screen, click Data Validation, and select Data Validation again from the ... In the Settings tab of the pop-up menu, under Source, adjust the cell range to include the new cell you entered data into, or to exclude the one you ...
DA: 95 PA: 93 MOZ Rank: 22