I have a Google Sheet that's being edited by 3 people, but each person needs to edit only one column. EX Red will edit red column; Blue will edit blue column and Yellow, well, yellow column hahaha.

How can I make that Red can't edit Yellow and Blue; Blue can't edit Red and Yellow, and Yellow can't edit Red and Blue?

I'm trying to avoid accidental changes. I tried with the Google Sheet menu where you can block columns, but it seems there is no way to block it the way I need it.

1 Answer 1

  • click on the column of your Red comrade
  • select Protect range
  • click on Set permissions


  • enter the email address of your red comrade

  • press Done


  • repeat for Blue and Yellow comrade

  • I did this before posting my question, but didn't work. When I do this, Google tells I need to grant access to the file so Red user can edit. When I grant access, Red can edit Yellow and Blue. I tried blocking the whole sheet except one column. It works for Red, but when I try to do so with Blue or Yellow, it says the sheet is already blocked. :'( Commented Aug 30, 2019 at 19:42
  • @RobertodeNobrega well, yes by granting access all users will be able to edit the sheet but those dedicated columns will be editable only by respective users eg. one per column. in other words. RED will be able to edit everything + his column but not BLUE+YELLOW columns
    – user0
    Commented Aug 30, 2019 at 19:45
  • 1
    hahahaha Know I got it.!! Thank you.!! It's working now. Thank youu..!!! Commented Aug 30, 2019 at 20:13
  • 1
    It worked very well, thanks!
    – thiagolr
    Commented Aug 2, 2021 at 15:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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