Protect an area of a spreadsheet

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

Procedure

  1. Open a spreadsheet.
  2. Activate the Contents tab bar.
  3. 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.

  4. Click Lock Protect > 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.