Protecting Cells

You can protect data in a spreadsheet in a number of ways. If you want to make sure that the data is secure, you can protect an entire spreadsheet. You also can selectively unprotect cells in a protected spreadsheet and lock a specific cell or group of cells.

When you lock, or protect, a cell or spreadsheet, you are preventing editing, replacement, or deletion of data. Columns and rows that contain protected cells cannot be deleted until you remove the protection.

To protect the entire spreadsheet

1.
Choose Format, Sheet Properties and click the Protection tab.
2.
Click the Enable Cell Locking check box.

To unlock a cell in a protected spreadsheet

1.
Select a cell.
2.
Click the Selection Properties button, or choose Format, ...

Get Absolute Beginner's Guide to WordPerfect® 12 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.