Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Cell Protection

Defines protection options for selected cells.

To access this command...

Choose Format - Cells - Cell Protection tab.

Protection

Hide all

Hides formulae and contents of the selected cells.

Protected

Prevents the selected cells from being modified.

This cell protection only takes effect if you also protect the sheet (Tools - Protect Sheet).

Hide formula

Hides formulae in the selected cells.

Print

Defines print options for the sheet.

Hide when printing

Keeps the selected cells from being printed.