You can use comments to leave remarks and collaborate with others in a spreadsheet, including @ mentioning others to notify collaborators. In this article, you'll learn how to use comments in Spreadsheets.
Add a Comment
To add a comment in a spreadsheet:
- Select a cell or group of cells.
- Right-click the selection and choose Add Comment from the dropdown menu.
- In the Comments panel, type your comment.
- 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.
You can use the Comment 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:
- Hover over a comment in the Comments panel.
- Click the drop-down arrow on the far right.
- Select the appropriate option from the drop-down menu.
- Resolve, delete or move the comment as desired.
To edit a comment, hover over the comment text until the pencil icon appears, then double-click to edit. To reply to a comment, click in the Reply field and enter your text. Then choose the Post button.
Navigate Among 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. Open the Comments panel using the Comments icon to the right to see all comments in the spreadsheet.
To move through the comments in a slide, 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.
The blue highlights in the spreadsheet indicate the presence of one or more comments for text, table cells and tables. When you click your cursor into highlighted content while the Comments panel is open, the corresponding comment will automatically expand in the comment panel and be indicated by a blue border.
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.
A comment icon next to a sheet’s name in the outline panel indicates that there are comments in that sheet. Hover over the icon to see the number of comments in the sheet.
If the text to which a comment is connected is removed from a document, an icon indicating that the comment has been disconnected will appear in the comment panel.
The content of the original selection (up to 400 characters of text) also appears in the appropriate comment card in the Comments panel.