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

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 Best 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

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 ID.