Protect an area of a spreadsheet

You can protect areas of a spreadsheet to prevent people from changing, moving, or deleting important data.

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. Click Output Output if the table is hidden.
  3. Activate the Data tab bar.
  4. Select the area of the spreadsheet you want to protect.

    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.

  5. Click Lock Protect.

The area of the spreadsheet is now protected from editing. To be able to edit this area again, you must unprotect the area.