Is there a way to protect cells with formulas in Numbers?

Unlike in Excel I don't find the possibility to lock individual cells with formulas in Numbers. This would be a great feature. I want to make an invoice template for a friend and find a way he doesn't type by mistake in a cell with a formula.

Posted on May 17, 2019 10:05 AM

Reply
Question marked as Top-ranking reply

Posted on May 17, 2019 11:02 PM

There is no way to lock individual cells in Numbers. But you can lock a table. You could put your calculations in a separate table and lock that, leaving the table with data input cells unlocked.


SG

1 reply

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.

Is there a way to protect cells with formulas in Numbers?

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