can you lock individual cells in numbers or can you only lock the whole table. how do you stop someone from tabulating the curser past the last one and unwantingly add another cell
Hi Christine,
You can lock a whole table, but not part of a table. One way is to have an input table that is not locked, and a results table that is locked.
That stops accidental overwriting of the formulas, or other accidental changes to the results table (such as the tab key inserting another column).
It won't stop someone from deliberately unlocking the table to do mischief.
Regards,
Ian.
Hi Christine,
You can lock a whole table, but not part of a table. One way is to have an input table that is not locked, and a results table that is locked.
That stops accidental overwriting of the formulas, or other accidental changes to the results table (such as the tab key inserting another column).
It won't stop someone from deliberately unlocking the table to do mischief.
Regards,
Ian.
thank you. I'm new to this spreadsheet as I have been using & creating templates on AppleWorks on an old computer for a long time now but need to upgrade spreadsheets for our small manufactory business Factory cutting sheets.. will try to work it out. hopefully will do. . maybe i'll be back to find out how to to what you said to do, butThanks again
Have worked it out!! Thank you so much! Appreciated. did the table with the formulas then selected the formulas and shifted them to another location, then locked these and went back to input cell and type amount and Voila! it works! Stoked!
Regards Christine
Hi Christine,
I am glad it worked 😀
Happy Numbering!
Ian
can you lock individual cells in Numbers or can you only lock the whole table. how do you stop someone from tabulating the curser past the last one and unwantingly add another cello
