Protection of formulas on numbers

Good morning everyone.


I would like to know if there is a way to protect the formula inside a cell, to prevent it from being accidentally changed or deleted.


Thank you

Posted on Jul 14, 2022 12:29 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 14, 2022 3:02 AM

If you can have most of your formulas in a particular table then you can lock that table.


But you can only lock a the table level. You cannot lock individual cells. And unlocking a table is easy, maybe not what you want.


Keep in mind that if you change a formula by mistake you can go back to the previous version via File > Revert to > Browse All Versions ... in the menu.


SG


1 reply
Question marked as Top-ranking reply

Jul 14, 2022 3:02 AM in response to the_a-f

If you can have most of your formulas in a particular table then you can lock that table.


But you can only lock a the table level. You cannot lock individual cells. And unlocking a table is easy, maybe not what you want.


Keep in mind that if you change a formula by mistake you can go back to the previous version via File > Revert to > Browse All Versions ... in the menu.


SG


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Protection of formulas on numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.