Does anyone know how to lock a column in Google Sheets without affecting other columns if there are any structural changes in the sheet. For example, I'm trying to lock one column, but when I try to remove any filters and changing the column size, it is showing a warning pop up that protection is being applied to one of the columns in this sheet.
Please let me know anyone how to solve this problem?
Best Answer
you can either Protect range... of column:
or Freeze column: