Is there any way to freeze formulars in Numbers. When I create a template for my employees to use they inadvertently delete the formular and I have to recreate it. Apple spread sheets used to have a way to freeze cells.
Mac mini, macOS 13.5
Nope. You must be thinking about Excel.
If it’s accidental, you can give your cells that have expressions in them a distinctive background color and tell your employees not to touch the cells with colored backgrounds. A little better is to place a Shape over the calculation cells’ area and set the background color to have zero opacity. This is different from No Background. Then Arrange> Lock the Shape. Now it will not be possible to click into or change the covered cells.
Alternatively, you can divide your table into two tables, one for entry and one for calculations. Then Arrange > Lock the entire calculation table.
Jerry
Nope. You must be thinking about Excel.
If it’s accidental, you can give your cells that have expressions in them a distinctive background color and tell your employees not to touch the cells with colored backgrounds. A little better is to place a Shape over the calculation cells’ area and set the background color to have zero opacity. This is different from No Background. Then Arrange> Lock the Shape. Now it will not be possible to click into or change the covered cells.
Alternatively, you can divide your table into two tables, one for entry and one for calculations. Then Arrange > Lock the entire calculation table.
Jerry
You can get a little protection from accidental overwriting of cells by locking a table. Click in the table and in the menu select Arrange > Lock. But note that locks the entire table, not just certain cells in it. If the design of your document permits you could try putting cells for user entry in one table and have the formulas in separate table(s), which you lock.
Of course, it is just as easy to unlock a table as to lock it, so this provides only limited protection. If you are doing a lot of collaboration where you need more robust protection then Excel or (I think) Google Sheets might be a better choice.
SG
Numbers formulars
