Feature Summary
The comment feature is used to add explanatory text in cells. It supports creating, editing, showing/hiding, and deleting 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 a Comment (Right-click Quick Insert)
Feature Entry
Right-click menu → "Insert Comment" button
- Select the cell where you want to add a comment
- Right-click the mouse
- Select the "Insert Comment" button from the menu
- Enter the description in the pop-up comment box
- Click anywhere on the spreadsheet to finish
- After insertion, a small red triangle indicator will appear in the upper right corner of the cell
- Hover the mouse to display the comment content

Create a Comment (Review Tab)
Feature Entry
"Review" tab → "New Comment" button
- Select the target cell
- Click the Review tab
- Select the "New Comment" button
- Enter the content and confirm

Edit a Comment
Feature Entry
Right-click menu → "Edit Comment" button
- Right-click the cell with a comment
- Select the "Edit Comment" button from the menu
- Once the comment box is activated, modify the content directly
- Click a blank area of the spreadsheet to confirm when finished

Edit a Comment (Review Tab)
Feature Entry
"Review" tab → "Edit Comment" button
- Select the cell with a comment
- Click the Review tab
- Select the "Edit Comment" button
- Enter the content and confirm

Show/Hide Comment via Right-click (Single Comment)
Feature Entry
Right-click menu → "Show/Hide Comment" button
- Right-click the cell with a comment
- Select the "Show/Hide Comment" button
- The show/hide state will be toggled

Show/Hide Comment via Review Tab (Single Comment)
Feature Entry
"Review" tab → "Show" dropdown menu → "Show/Hide Comment" button
- Select the cell with a comment
- Click the Review tab
- Click the Show dropdown menu
- Select the "Show/Hide Comment" button
- The show/hide state will be toggled

Show All Comments
Feature Entry
"Review" tab → "Show" dropdown menu → "Show All Comments" button
- Click the Review tab
- Click the Show dropdown menu
- Select the "Show All Comments" button
- All comments in the spreadsheet will be displayed at once

Delete a Comment (Right-click Delete)
Feature Entry
Right-click menu → "Delete Comment" button
- Right-click the cell with a comment
- Select the "Delete Comment" button from the menu

Delete a Comment (Review Tab Delete)
Feature Entry
"Review" tab → "Delete Comment" button
- Select the cell with a comment
- Click the Review tab in the top menu bar
- Select the "Delete Comment" button to complete

Previous/Next Comment
Feature Entry
"Review" tab → "Delete Comment" button
- Click the Review tab
- Click the "Previous" or "Next" button. Automatically jump to the previous or next comment

Reset Current Comment
Feature Entry
"Review" tab → "Reset Current Comment" button
- Select a cell with a comment
- Click the Review tab
- Click the "Reset Current Comment" button
- Restore the format, size, and position of the selected comment to the default state

Reset All Comments
Feature Entry
"Review" tab → "Reset All Comments" button
- Click the Review tab
- Click the "Reset All Comments" button
- Restore the format, size, and position of all comments in the worksheet to the default state

Set Comment Format
Feature Entry
Right-click menu → "Set Comment Format" button
- Select the comment box
- Right-click the comment box and select the "Set Comment Format" button
- Adjust the font, size, color, etc. of the comment in the dialog box

Notes
- The comment feature is used to add explanatory text to cells and does not modify cell content
- After inserting a comment, a small red triangle indicator will appear in the upper right corner of the cell
- Hover the mouse over a cell with a comment to display the comment content
- All comments can be shown or hidden in bulk via the Review tab