numbers

is it possible to lock a formula in a cell?

MacBook Pro 13″, macOS 10.15

Posted on May 1, 2021 5:58 PM

Top-ranking reply

Barry

Level 9

60,023 points

Posted on May 1, 2021 6:16 PM

Only by locking the table containing that cell.

Locking is a menu item, and the menu is accessible by any user of the document, so this is an 'accident prevention' action, not a 'security measure.'

Regards,

Barry

View in context

Similar questions

lock formulas Is it possible to lock the formulas in numbers. I know you can lock the whole sheet which locks the formulae but then you can’t change any variables that you want to see the effect of.
1049 2
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
602 1
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.
712 1

1 reply

Top-ranking reply

Barry

Level 9

60,023 points

May 1, 2021 6:16 PM in response to wetcoaster

Only by locking the table containing that cell.

Locking is a menu item, and the menu is accessible by any user of the document, so this is an 'accident prevention' action, not a 'security measure.'

Regards,

Barry

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.

numbers