You can use comments to leave remarks and collaborate with others in a spreadsheet, including @ mentioning others to notify collaborators.
Add a Comment
To add a comment in a spreadsheet:
- 1
- Single-click a cell or group of cells.
- 2
- Right-click the selection and choose Add Comment from the dropdown menu.
- 3
- In the Comments panel, type your comment.
- 4
- Click Post to add your comment.
You can mention both individual users and workspace groups to notify them directly about your comment. Type @ in the comment box to view a list of users and existing groups, including document owners, editors, or viewers.
Manage Comments
You can use the Comments panel to manage your spreadsheet's comments. If you are a document owner, you can create, reply to, resolve, move, and delete comments. If you are an editor or viewer, you can perform any of these actions but can only delete your own comments.
To manage comments:
- 1
- Hover over a comment in the Comments panel.
- 2
- Click the arrow.
- 3
- Select an option from the dropdown menu.
You can edit an existing comment by clicking the pencil icon. To reply to a comment, type your response in the text field.
Navigate Between Comments
When someone comments on a sheet, the comment icon appears next to the sheet in the document outline as well as in a circle to the left of the comment in the Comments panel.
To move through your comments, use the Move Up and Move Down arrows at the top of the Comments panel. You can view a comment’s selection in the document by clicking the Jump to Location icon.
Blue triangle outlines in the spreadsheet indicate there are comments for that cell.
When you click highlighted content while the Comments panel is open, the corresponding comment automatically expands in the Comments panel.
Filter Comments
To filter your comments, click the Filter icon in the Comments panel. Use the radio buttons at the top of the panel to show comments for your entire document or just the selected sheet.
Reset your filters by clicking Reset Filters at the bottom of the filter window.
Disconnected Comments
If the text your comment is connected to is removed from your spreadsheet, a disconnected icon appears next to the comment in the Comments panel. The comment's original selection (up to 400 characters) also appears in the comment card.
To reconnect your comment, select a new cell in your document and select Reconnect Comment in the Comments panel.