You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

the_a-f Author

Level 1

4 points

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

Top-ranking reply

SGIII

Level 8

36,134 points

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.

View in context

Protection of formulas on numbers

Similar questions