Unprotect table

If you have protected an area of a spreadsheet against editing, you can unprotect it again.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.

  2. Activate the Data 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 area of the spreadsheet can now be edited again.