Ask Your Question
0

How do I set the default value cell [closed]

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

DK gravatar image

Hi,

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
0

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

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

2 followers

Stats

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

Seen: 2,148 times

Last updated: Aug 17 '13