When using Auto Hide Content, common questions focus on permission differences, who can still view hidden data, and whether the original values remain available; this FAQ includes 3 common questions and a glossary.
FAQ
What is the difference between Auto Hide Content and range permissions?
- Range permissions are mainly used to limit who can modify data.
- Auto Hide Content is mainly used to limit who can directly view sensitive content.
- If you need to control both editing and viewing, you can use protected ranges together with Auto Hide Content.
Can all collaborators no longer see hidden content?
- No. Hidden content is not blocked for every collaborator.
- The document creator, fillers, and users added to the designated list can still view the hidden range.
- Unauthorized collaborators see the content as
●.
Is the original data still there after Auto Hide Content is turned on?
- Yes. The feature changes how the content is displayed and does not remove the original data.
- After Auto Hide Content is turned off, the original values display normally again.
- If review is needed, an authorized user can view the content or turn off the hidden state.
Glossary
| Term | Definition |
|---|---|
| Collaboration mode | A working mode where multiple people work on the same spreadsheet online and where related permission and hidden-content features take effect. |
| Protected range | A cell range in a spreadsheet that has its own protection or permission rules. |
| Designated persons to manage hidden content | A setting that lets the document owner grant specific collaborators permission to view hidden content in a protected range. |