Ask Your Question

How do I set the default value cell [closed]

asked 2013-08-17 09:24:34 +0200

DK gravatar image


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?

Regards - DK

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 02:13:56.514285

1 Answer

Sort by » oldest newest most voted

answered 2014-12-04 13:54:25 +0200

reddish gravatar image

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.

edit flag offensive delete link more

Question Tools



Asked: 2013-08-17 09:24:34 +0200

Seen: 2,541 times

Last updated: Aug 17 '13