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

  1. Select the cell where you want to add a comment
  2. Right-click the mouse
  3. Select the "Insert Comment" button from the menu
  4. Enter the description 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

image

Create a 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 the content and confirm

image

Edit a Comment

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

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

image

Edit a 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 the content and confirm

image

Show/Hide Comment via Right-click (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. The show/hide state will be toggled

image

Show/Hide Comment via Review Tab (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. The show/hide state will be toggled

image

Show 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. All comments in the spreadsheet will be displayed at once

image

Delete a 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 from the menu

image

Delete a 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

image

Previous/Next Comment

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

  1. Click the Review tab
  2. Click the "Previous" or "Next" button. Automatically jump to the previous or next comment

image

Reset Current Comment

Feature Entry
"Review" tab → "Reset Current Comment" button

  1. Select a cell with a comment
  2. Click the Review tab
  3. Click the "Reset Current Comment" button
  4. Restore the format, size, and position of the selected comment to the default state

image

Reset All Comments

Feature Entry
"Review" tab → "Reset All Comments" button

  1. Click the Review tab
  2. Click the "Reset All Comments" button
  3. Restore the format, size, and position of all comments in the worksheet to the default state

image

Set Comment Format

Feature Entry
Right-click menu → "Set Comment Format" button

  1. Select the comment box
  2. Right-click the comment box and select the "Set Comment Format" button
  3. Adjust the font, size, color, etc. of the comment in the dialog box

image

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