I have in cell A2 a dropdown list using data validation so that a user can enter value from the populated list. The values are in Cell range C2:C6 which appears as dropdown list in cell A2. I am looking for a solution to set a default value as "-selsct from list-" when the work book is open always for entering datas.
Bookmarks