How to Use WPS Auto Hide Content on Windows

Use Auto Hide Content with 3 how-to topics, including 3 free topics and 0 membership-related topics; start from the index and jump to the steps you need.

How-to Index

How-to Guide

1. Turn on Auto Hide Content from the right-click menu

Entry: Select a cell range → right-click → Turn on Auto Hide Content

1. Select the cell range whose visible content you want to hide.
2. Right-click anywhere inside the selected range.
3. Click Turn on Auto Hide Content in the shortcut menu.
4. Confirm that the selected range now displays as ●.
5. Continue sharing the sheet as needed.

Success Criteria

• Interface result: The target range displays as ●.
• You can continue: Owners, fillers, or specified users can still manage the range afterward.

Tips While Using

• Common mistake: If you do not select the target range first, the shortcut menu action may not apply to the intended cells.
• Environment note: This feature is more suitable for collaborative spreadsheet scenarios.

2. Turn on Auto Hide Content from the Collaboration tab

Entry: Select a cell range → Collaboration → Protected Range → Auto Hide Content

1. Select the cell range you want to hide.
2. Click the Collaboration tab at the top.
3. Click Protected Range.
4. Choose Auto Hide Content from the drop-down menu.
5. Check whether the selected range has switched to the hidden display state.

Success Criteria

• Interface result: The target range enters the hidden display state.
• You can continue: You can click the range later and open its management menu for more settings.

Tips While Using

• Common mistake: If the current file is not being used as a collaborative sheet, the available entry may differ from a regular local spreadsheet.
• Environment note: It is recommended to stay signed in and use the feature in a file that supports collaboration.

3. Manage an existing Auto Hide Content range

Entry: Click a hidden cell → green shield icon

1. Click a cell in a range where Auto Hide Content is already enabled.
2. Wait for the green shield icon to appear on the left side of the cell.
3. Click the green shield icon to open the management menu.
4. Choose Ignore the first X rows, Assign specific users to manage content, or Turn off Auto Hide Content as needed.
5. Return to the sheet and confirm that the display result matches your settings.

Success Criteria

• Interface result: The green shield icon appears and opens the management menu.
• You can continue: You can adjust visible header rows, assign who can view the content, or turn the feature off.

Tips While Using

• Common mistake: If you do not click a range where Auto Hide Content is already enabled, the related management entry will not appear.
• Environment note: Assigned-user management usually depends on an existing collaboration relationship and signed-in account permissions.