Protecting Numbers cells

Reader Bob Thornton professes to be a simple user with a simple question, and that question is:

In Numbers, when you create a formula how do protect that cell so that someone can not accidently erase the formula?

The simple answer is: You can't, at least not in the way you can protect Excel cells. A small consolation is that you can lock tables. So, you could create a table for your numeric masterpiece, select the table, and then choose Arrange -> Lock. Your work would be safe until someone chooses to unlock the table.

Another technique recommended in Apple's Discussion Forums is to do your work and then plant a rectangle over the area you don't want changed, select that rectangle, open the Inspector, click the Graphic tab, move the Opacity slider all the way to the left (0%), and choose Arrange -> Lock to lock the shape in place. The work beneath the shape will shine through but no one will be able to muck with it unless they unlock the shape and either move it or send it into the background.

Shop ▾
arrow up Amazon Shop buttons are programmatically attached to all reviews, regardless of products' final review scores. Our parent company, IDG, receives advertisement revenue for shopping activity generated by the links. Because the buttons are attached programmatically, they should not be interpreted as editorial endorsements.

Subscribe to the Apple @ Work Newsletter