Unprotect an area of a spreadsheet

If you have protected areas of a spreadsheet against editing, you can unprotect them again.

Procedure

  1. Open a spreadsheet.
  2. Activate the Contents tab bar.
  3. Select the area of the spreadsheet you want to unprotect.

    You can select an entire row or column by clicking the row or column header. You can select rows or columns that are adjacent by holding down the Shift key.

  4. Click Lock Protect > Unlock Unprotect.

The selected area of the spreadsheet can now be edited again.