Skip to content

start:

This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

How do I protect cells in my spreadsheet?

Cell protection is active for all cells by default. If only certain cells are to be protected, this setting must be turned off.

  • Select the entire spreadsheet. (A quick way is to click the little gray box above row 1 and to the left of column A.)
  • From the pull-down menus, select Format > Cells.
  • In the dialog that appears, select the Cell Protection tab.
  • Uncheck the box next to Protected to remove the protection on all cells.

To select a range of cells to protect, or to select non-adjacent cells to protect:

  • Hold down the Ctrl key while clicking on the non-adjacent cells to highlight the ones that are to be protected.
  • When all of the desired cells are selected, in the pull-down menus, go to Format > Cells...
  • In the dialog that appears, select the Cell Protection tab.
  • Click on the box next to Protect.
  • Click OK.

Once the cells are marked for protection, the protection option must be enabled at the sheet or spreadsheet level:

  • From the pull-down menus, select Tools > Protect Document > Sheet or Tools > Protect Document > Document.
  • In the dialog that appears, provide a password , then confirm it by typing it again.
  • Click OK.
  • The protected cells will now be uneditable.

Documentation / User FAQ / Calc / Previous-Next