Calc: How do I use discrete (text) values?
Calc: How do I use discrete (text) values?
There are many cases when people might want to have a dropdown list of the other entered values in a column.
And the ability to prohibit entering others.
Classic one: entering yes, no, maybe.
These are not boolean, but discrete, and others should not be allowed.
Do you know how to do that?
Answer
select your range D25:D99, then menu Data->Validity In dialogue Validity select from drop-down list variant “Cell range”, and bottom set “Source” (your H3:H25) Push OK
Here is an example.
Thanks @[email protected]
Ende Gelände!
You're viewing a single thread.
All Comments
4 comments
Is there a "remindme" bot in lemmy?
I want to know the answer too.
2 0 Reply