How Do I Unprotect a Cell in OpenOffice Calc?

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Calc displays an error when you try to edit protected cells.
Image Credit: Image courtesy of Apache

By default, a protected spreadsheet in OpenOffice Calc 4 protects every cell, preventing anyone from editing their contents. To unprotect specific cells on the sheet, you first need to turn off protection for the entire sheet. Set the specific cells to not use protection, and then re-enable sheet protection on the rest of the sheet.

Advertisement

Step 1

Keyboard shortcut: Alt-T-P-S.
Image Credit: Image courtesy of Apache

Open the Tools menu, point to Protect Document and uncheck Sheet. If the spreadsheet's creator locked the sheet using a password, you'll need it to turn off protection.

Advertisement

Video of the Day

Step 2

Keyboard shortcut: Ctrl-1.
Image Credit: Image courtesy of Apache

Select the cells you want to unprotect by clicking and dragging, clicking a column or row header, or holding Ctrl while clicking each cell. Open the Format menu and click Cells to format the selection.

Advertisement

Step 3

Protected is checked by default, but has no effect without sheet protection enabled.
Image Credit: Image courtesy of Apache

Turn off Protected on the Cell Protection tab and click OK.

Advertisement

Step 4

At this point, it doesn't matter which cells are selected.
Image Credit: Image courtesy of Apache

Reopen the Tools menu and click Sheet in the Protect Document section when you're ready to reprotect the rest of the spreadsheet.

Advertisement

Advertisement

Step 5

Other options on this window let you prevent users from selecting cells.
Image Credit: Image courtesy of Apache

Enter a password if you want one, and click OK to turn on protection. The cells you formatted remain unprotected and editable, while the rest of the sheet locks down.

Video of the Day

Advertisement

Advertisement

references & resources