Locking Cells

• Marking Cells As Locked
• Locking the Sheet
• Clearing Cells That Are Marked as Locked
• Unlocking the Sheet
• Setting Background and Text Colors for Locked Cells

Overview

You can lock cells to prevent editing. To do so, you first mark cells as locked, then tell the sheet to lock the marked cells. You can remove the locked status from marked cells to edit them, and you can change cells so that they are no longer marked as locked.

To indicate that cells are marked as locked, you can change their background and text colors. The settings for the background and text colors for cells marked as locked override the settings for the individual cell, the column, the row, or the sheet.