Numbers: How to lock the table without locking the ability to edit what's inside?
all in title
Thank you
MacBook Air (13-inch Mid 2013), OS X El Capitan (10.11.2)
Question marked as
Best reply
Hi Berendirih,
Not possible. Locking the table prevents changes to the table and to its contents.
As much as possible, you should separate input and calculations onto their own tables. Lock the calculation tables to protect the formulas. Leave the data entry tables unlocked to permit data entry.
Regards,
Barry