I have a protected range but I want to do the opposite of its function. I only want a user to be edit that specific range.

So, how can I have them "view only" for the whole spreadsheet but edit one specific range?

  • 3
    Except for the perhaps obvious solution; to protect the rest of the sheet, but not that particular column? – Vidar S. Ramdal Mar 7 '14 at 23:49
  • That probably does work I guess but I was trying to avoid that to prevent the checkered lines all throughout with the rest being protected; they still need to be able to clearly read the rest of the spreadsheet. – user48742 Mar 8 '14 at 3:32

Protect the sheet and apply an exception.

  1. Right click the sheet's tab
  2. Select protect
  3. On the sidebar, mark the checkbox "Except certain cells". This will display a field to set the cells that will be editable
  4. Click on the button "Set permissions"
| improve this answer | |

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.