How to Use WPS Auto Hide Content on macOS

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 menu → Turn on Auto Hide Content

1. Select the cell range whose displayed 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. After it is enabled, the content in that range is shown as ●.
5. The document owner, form fillers, and specified users can still view the original content.

Success Criteria

• Visual result: The original content in the selected range is replaced by ● on screen.
• Next action available: You can continue editing other areas or open the management options later.

Tips While Using

• Common mistake: If you do not select the target range first, the command may not apply to the intended cells.
• Environment note: In collaborative scenarios, keep a network connection when possible so permission status can sync in time.

2. Turn on Auto Hide Content from the Collaborate tab

Entry: Select a cell range → Collaborate → Protect Range → Auto Hide Content

1. Select the cell range whose displayed content you want to hide.
2. Click the Collaborate tab at the top of the window.
3. Click Protect Range on the toolbar.
4. Choose Auto Hide Content from the menu.
5. Confirm the action so the selected range enters the hidden display state.

Success Criteria

• Visual result: The target range no longer shows the original content directly and appears in a hidden display style.
• Next action available: You can continue managing the range from the related Protect Range entry.

Tips While Using

• Common mistake: If you open the menu before selecting a range, you may need to reselect the target cells.
• Environment note: This entry is available in Smart Spreadsheet.

3. Manage a range with Auto Hide Content already enabled

Entry: Click a cell with Auto Hide Content enabled → 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 shield icon to open the management menu.
4. Choose Ignore first X rows, Assign specific people to manage content, or Turn off Auto Hide Content as needed.
5. Return to the sheet after the setting is updated.

Success Criteria

• Visual result: The management menu opens normally and shows the available options.
• Next action available: You can adjust hidden-range rules, assign viewers, or turn the hidden state off.
• No unwanted change: If you turn the feature off, the data is shown again and the underlying content remains unchanged.

Tips While Using

• Common mistake: If you do not click a cell in a hidden range first, the shield entry will not appear.
• Environment note: Ignoring the first X rows is useful when header rows should remain visible.