Question: how to change value of dropdown in excel?
Answer: On the worksheet where you applied the drop-down list, select a cell that has the drop-down list.
Go to Data > Data Validation.
On the Settings tab, click in the Source box, and then change your list items as needed.