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?

  • 1
    I don't think it's possible, if you delete a row it necessarily alters a protected cell. Nothing you can do about it – Cornelius Roemer Sep 29 '19 at 12:27
  • If you are still looking for help on this please clarify what you mean by "column lock" as this term in not something that is included in support.google.com/docs – Rubén Jan 26 at 16:34
  • you can either Protect range... of column:


  • or Freeze column:


| improve this answer | |
  • 1
    Hey Thanks for your reply. I really appreciate. But I know how to apply protection in any column. What's the issue the I'm facing is that when I am trying to apply protection in one of the column and makes any changes in the sheet like removing filters and resizing columns then it is asking to remove the protection first although I am not making any changes in that column but it is affecting whole sheet. I just want to know how to protect column so that it should not disturb other columns in the sheet when making changes to part of the sheet? – Rohit Gupta May 2 '19 at 3:20
  • @RohitGupta can you share a copy/dummy of your sheet for debugging? – user0 May 2 '19 at 3:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.