Protecting cells

You will sometimes want to protect cells in your worksheet so that they cannot be edited. New data cannot be entered into protected cells and any formulae contained in them cannot be edited or replaced.

Protection is turned on using the Number section of the style editor. You are advised to set up a style whose only attribute is protection, so that you can apply protection to cells as flexibly as possible. Or you may like to add a background colour to the number protection style, so that you can see on screen which cells have been protected.