When using Auto Hide Content, the most common questions are about display behavior, search behavior, and permission differences; this FAQ covers 5 frequent questions and a glossary.
FAQ
What is the difference between Auto Hide Content and Wrap Text?
- Auto Hide Content hides the visible content in selected cells and usually shows
●in the interface. - Wrap Text increases row height so the text can be displayed across multiple lines.
- If your goal is privacy for sensitive values, use Auto Hide Content. If your goal is better text display, use Wrap Text.
Can hidden content still be searched?
- Users who have permission to manage or view the hidden content can still access the original values.
- When the content is visible to an authorized user, it can still be searched normally.
- Users without viewing permission only see the masked display result.
What is the difference between Auto Hide Content and range permissions?
- Range permissions mainly control whether other people can edit a specific area.
- Auto Hide Content mainly controls whether other people can directly see the content in that area.
- If you need both visibility control and edit control, you can combine the two settings.
Can all collaborators no longer see the hidden content?
- No. The restriction does not apply to every collaborator in the same way.
- The document creator, fillers, and users added to the specified list can still view and edit the related content.
- Unauthorized collaborators see the masked display instead.
Does the original data stay in the sheet after Auto Hide Content is turned on?
- Yes. The feature changes the display state and does not delete the original cell data.
- When you turn Auto Hide Content off, the original values appear again.
- For long-term protection of sensitive information, also manage sharing scope and permissions carefully.
Glossary
| Term | Definition |
|---|---|
| Auto Hide Content | A feature that hides the visible content of selected spreadsheet ranges so unauthorized users see a masked result. |
| Protected Range | A range setting in a collaborative spreadsheet used to control visibility or editing behavior for selected cells. |
| Assigned-user content management | A setting that keeps viewing or management access for specific collaborators. |
| Ignore the first X rows | An option that keeps the first few rows visible, often used to preserve readable headers. |
| Green shield icon | The interface marker that appears for a hidden range and opens its management menu. |