How do I set the default value cell


In my sheet I have cells in which the user can pick a value from a list. I want to make one of the list values as the default value.

How can I do this?


  • DK

Could not find a way to do it with the data validity function. A workaround would be to prefill the cells with the default value, or use an “IF” to fill it with the default value when some conditions are met. Then, any value picked from the validity list will overwrite the formula, but if none is selected, the default will remain.