Lock Column (or Row)

Lock Column (or Row)

If you want to protect key data from being changed by those shared to your sheet as 'Editors', you can lock columns or rows.  There are three rules for the lock feature:

  1. Only the sheet owner or admins can lock or unlock columns/rows on a sheet
  2. The sheet owner and admins can still edit locked columns/rows
  3. Editors on the sheet can see locked columns/rows, but they cannot edit the data in locked columns/rows

The lock feature is available from the column or row menus.  The attachment and discussion columns cannot be locked.  A lock icon will be displayed in the column or row headers to indicate that a column or row has been locked.

Lock-screenshot-help3.PNG