WPS Sheets Add/Delete Comment Guide

Feature Summary

The comment feature is used to add descriptive text in cells, supporting creation, editing, show/hide, and deletion of comments, helping users explain data during collaboration and improving communication efficiency.

Feature Description

Feature Dimension	Description
Membership Restriction	No membership restriction
Version Restriction	No version restriction
Insert Comment Shortcut	Shift+F2

Operation Steps

Create Comment (Right-click Quick Insert)

Feature Entry
Right-click menu → "Insert Comment" button

1. Select the cell where you want to add a comment
2. Click the right mouse button
3. Select the "Insert Comment" button in the menu
4. Enter the description content in the pop-up comment box
5. Click anywhere on the spreadsheet to finish
6. After insertion, a small red triangle indicator will appear in the upper right corner of the cell
7. Hover the mouse to display the comment content

Create Comment (Review Tab)

Feature Entry
"Review" tab → "New Comment" button

1. Select the target cell
2. Click the Review tab
3. Select the "New Comment" button
4. Enter content and confirm

Edit Comment

Feature Entry
Right-click menu → "Edit Comment" button

1. Right-click the cell with a comment
2. Select the "Edit Comment" button in the menu
3. After the comment box is activated, modify the content directly
4. Click on a blank area of the spreadsheet to confirm when done

Edit Comment (Review Tab)

Feature Entry
"Review" tab → "Edit Comment" button

1. Select the cell with a comment
2. Click the Review tab
3. Select the "Edit Comment" button
4. Enter content and confirm

Right-click Show/Hide Comment (Single Comment)

Feature Entry
Right-click menu → "Show/Hide Comment" button

1. Right-click the cell with a comment
2. Select the "Show/Hide Comment" button
3. Toggle the show/hide state

Review Tab Show/Hide Comment (Single Comment)

Feature Entry
"Review" tab → "Show" dropdown menu → "Show/Hide Comment" button

1. Select the cell with a comment
2. Click the Review tab
3. Click the Show dropdown menu
4. Select the "Show/Hide Comment" button
5. Toggle the show/hide state

Show/Hide Comments (All Comments)

Feature Entry
"Review" tab → "Show" dropdown menu → "Show All Comments" button

1. Click the Review tab
2. Click the Show dropdown menu
3. Select the "Show All Comments" button
4. Display all comments in the spreadsheet at once
5. Click again to hide all

Delete Comment (Right-click Delete)

Feature Entry
Right-click menu → "Delete Comment" button

1. Right-click the cell with a comment
2. Select the "Delete Comment" button in the menu

Delete Comment (Review Tab Delete)

Feature Entry
"Review" tab → "Delete Comment" button

1. Select the cell with a comment
2. Click the Review tab in the top menu bar
3. Select the "Delete Comment" button to complete

Previous/Next Comment

Feature Entry
"Review" tab → "Delete Comment" button

1. Click the Review tab
2. Click the "Previous" or "Next" button3. Automatic Navigation to Previous or Next Annotation

Reset Current Annotation

Function Access
"Review" tab → "Reset Current Annotation" button

1. Select the cell containing an annotation.
2. Click the Review tab.
3. Click the "Reset Current Annotation" button.
4. The format, size, and position of the selected annotation will be restored to their default states.

Reset All Annotations

Function Access
"Review" tab → "Reset All Annotations" button

1. Click the Review tab.
2. Click the "Reset All Annotations" button.
3. The format, size, and position of all annotations in the worksheet will be restored to their default states.

Set Annotation Format

Function Access
Right-click menu → "Set Annotation Format" button

1. Select the annotation box.
2. Right-click the annotation box and select the "Set Annotation Format" button.
3. Adjust the annotation's font, size, color, etc., in the dialog box that appears.

Important Notes

• The annotation feature is used to add explanatory text within a cell; it does not modify the cell's content.
• After inserting an annotation, a small red triangle indicator will appear in the upper-right corner of the cell.
• Hovering the mouse over a cell with an annotation will display the annotation content.
• Annotations support multi-user collaboration and discussion; replies can be added.
• You can batch display or hide all annotations using the Review tab.