Home Blog Archive MS Office LibreOffice: protect cells from Changes

LibreOffice: protect cells from Changes

  • Aug 14, 2020
  • 133
  • 0

How to protect cells in LibreOffice prior to the Changes, we will explain in this practical tip-guide.

Cells in LibreOffice, protect

In LibreOffice cells against accidental Changes to protect. For this, follow the following steps.
  1. Select under the menu item "tools" the Option "protect document" and click on "table".
  2. If you enter a password, the document can be edited only when you switch it on by entering your password again. The password is optional - you can also protect just the cells, without setting a password.
  3. If you confirm the operation by clicking "OK" will protect all the cells of your document. However, you can also select specific cells can still be edited.
  4. To do this, select all the cells that are not to be of the protection being affected. Then, select in the menu "Format" and click on "cells".
  5. You remove cell protection, check "Locked" and confirm with "OK".
Protecting cells in a LibreOffice
  • Alternatively, you can hide with a check in the "hide formula" all of the formulas, in order to protect them from Changes. By clicking on "For expression to hide the" don't display any cells still in the document, in the case of an expression, however.

Document protect against foreign insight

The above-mentioned procedure, however, is not a complete safe guard because of the protection of the document can be by converting into another document repealed.
  1. Secure the Save in the OpenDocument Format with password protection. To do this, select "Save as"
  2. Then put a check in the "save With password".
  3. You can then set a password that must be entered each time you Open the file.
LibreOffice: set password
In the next practical tip we show you how to in LibreOffice, the conditional formatting use.