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