Viewing comments in spreadsheets

When you open a spreadsheet, if the sidebar is not displayed by default, you can select to show the sidebar. Then, you can filter and view all comments and responses in this spreadsheet in the collaboration sidebar.

About this task

When editing a spreadsheet, you can view and filter all comments within a spreadsheet to more easily track comments and response threads. You can sort and view comments and responses that are directed at you or created by you, comments that are currently being discussed, or comments that are resolved.

Procedure

To view and filter comments and responses, follow these steps:

  1. When you open a spreadsheet, if the sidebar is not displayed by default, you can click the sidebar icon sidebar icon to show the sidebar.
  2. Click All Comments on the sidebar and select one of the following filtering options from the list. A number next to the filter option indicates the number of unread comments.
    • Select @ me to view all comments that are directed at you, including their response threads.
    • Select By Me to view comments that are written by you. This includes responses you have written to other editor's comments.
    • Select Active to view comments that are currently being discussed.
    • Select Resolved to view comments that have been marked as resolved.