Question: how to auto select dropdown value in excel?
Answer: Create a drop down list. ... 
Then in the Data Validation dialog, under Settings tab, select List from Allow list, and then select the value you want to show in the drop down list to Source textbox.