Ask Your Question

Turning off selection list in Calc

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

jijipetorin gravatar image


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 +0200

Lupp gravatar image

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

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 +0200

Seen: 462 times

Last updated: Nov 13 '16