• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

Google Docs - Prevent viewing of cell range


How can I prevent users of a shared Google Docs spreadsheet from viewing certain cell ranges? I know how to define a range and put permissions on it, but it always seems to still allow people to see (though somewhat redacted) information in the cells. Though I can take away their permissions to edit, I can't seem to take away the ability to see it at all...Any ideas?

  • 2
1 Solution
Brad RubinCommented:
I am not sure what you are trying to do is possible. You can protect a sheet and hide, but anyone with shared access should be able to see or unhide the hidden cells.

I am not sure what you are trying to protect, but if you have sensitive data, you can create separate sheets for users and then import data into a master sheet for yourself. That seems like  a lot of work, but if it solves your problem, it may help.

I wish I could be more help to you.
cipherlogicAuthor Commented:
Thanks :(
Brad RubinCommented:
I actually did do some more research for you. It sounds like it is a limitation of Google. The good news is they know it is a problem and may address it in future releases of Google Apps.

Check out the Google Product Forums for updates: https://productforums.google.com/forum/#!forum/docs

Sorry this wasn't the answer you wanted, but let us know if we can help you more.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now