Creating and acting on comments in spreadsheets

When you edit or review a spreadsheet, you can create one comment per cell. All comments and responses for the spreadsheet are displayed in the collaboration sidebar.

About this task

The comments you create stay associated with the cell they refer to. The collaboration sidebar acts as a record of all comments in the spreadsheet where you can easily see the most recent comments and responses. In spreadsheets, you can create comments only for cells, and only one comment per cell.

Procedure

  1. Click any cell that want to create a comment for.
  2. Click Team > Add Comment. A new comment box is displayed.
  3. Type your comment in the field and click Post. The comment stays associated with the cell in the spreadsheet and is also displayed in the sidebar with your name and the date and time that the comment was created.
    Commenting dialog
    Tip: If you want to direct the comment at a co-editor, enter the @ symbol. A list of editors of the spreadsheet is displayed. Select the editor that you want from the list, and then enter your comment. When a comment is directed at you, you receive a notification in the @ Mentions section of Connections and an email, if specified by your Connections notifications settings.
  4. To interact with comments, click the comment in the sidebar to open the in-text comment box. For an active comment, you can also display the in-text comment box by hovering over the corresponding comment marker in the cell. You can interact with comments in the following ways:
    Task Action
    Reply Respond to a comment.
    View more replies or View fewer replies View the full thread of responses for a comment with more than two replies.
    Resolve Mark a comment as resolved. The comment becomes gray to indicate its resolved status and the marker is removed from the cell. A resolved comment's in-text box can only be accessed by clicking the comment in the sidebar.
    Reopen Reopen a resolved comment.
    Delete Remove a comment from the spreadsheet. The comment and its replies are removed from the sidebar and the in-text comment box with the corresponding marker is removed from the cell.