Ask Your Question

Turning off selection list in Calc

asked 2016-11-13 17:18:29 +0100


I made a selection/drop-down list in calc for my bank account for different reoccurring movement details (paying account rates, moving money to paypal or savings accounts, etc.) but there are certain movements that are not reoccurring (buying from certain stores, etc).

How do I turn off the list for certain cells?

Thank you ! Jasper

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-11-13 18:44:30 +0100

Lupp gravatar image

updated 2016-11-13 18:46:29 +0100

The 'Data Validity' tool is working by imposing a property on the cell handled like a direct formatting. Ctrl+M will clear it together with any direct formatting.
If you want to have other direct formatting persist, you can go 'Data' > 'Validity...' and choose 'Allow:' > 'All values'.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-13 17:18:29 +0100

Seen: 273 times

Last updated: Nov 13 '16