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.

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

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.