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

Unprotecting Cells

  1. Click the sheet for which you want to cancel the protection.

  2. Select Tools - Protect Sheet or Tools - Protect Spreadsheet Structure to remove the check mark indicating the protected status.

  3. If you have assigned a password, enter it in this dialogue box and click OK.

The cells can now be edited, the formulae can be viewed, and all cells can be printed until you reactivate the protection for the sheet or document.