Comments are one of the useful features that allow you to collaborate in Google Sheets. Users will be able to provide feedback, suggestion, and tag contacts in the comments. In this article, let us understand how to Add, Edit, View, Filter, And Delete the comments in Google Spreadsheet with the help of Google Sheet tips provided on this page. Read on to find more.

Table Of Contents

How to Add a Comment in Google Sheets?

To add a comment in google sheets, you need to follow the below steps.

  • Step-1: Click on the cell that you need to add the comment
  • Step-2: To add the comment, click on the Add comment icon which is available in the toolbar

add comment google sheets

Additionally, you can also right-click on the cell for which you want to add a comment and select the Comment option. Also, the keyboard shortcut key would be Ctrl+Alt+M

  • Step-3: Type your Comment that you want to add

add comment google sheets

  • Step-4: Click on the Comment which is highlighted in green color in the above image.

add comment google sheets

You could see in the above image, the comment is added to A1 cell.

How to Edit a Comment in Google Sheets?

You can always edit a comment which you have added. To Edit the comment in the google sheets, you need to follow the below steps.

  • Step-1: Click on the cell that you need to edit the comment
  • Step-2: Click on the More icon and select the Edit option.

add comment google sheets

  • Step-3: Type the new message and click on the save

add comment google sheets

How to View a Comment in Google Sheets?

To view the comment in the google sheets, you need to follow the below steps.

  • Step-1: On the top right page, click the Open comment history icon

add comment google sheets

  • Step-2: Now you can view all the comments. To close, click on the same Open comment history icon again.

Additionally, At the bottom of any comment window, you can also click Open all comments.

How to Find a Comment in Google Sheets?

To find the comment in the google sheets, you need to follow the below steps.

  • Step-1: On the top right page, click the Open comment history icon
  • Step-2: Click on the cell name, you could see the comment and its location in google sheets

add comment google sheets

Additionally, To see all comments in the sheet, click See all comments from the drop-down list.

How to Filter a Comment in Google Sheets?

To Filter the comment in the google sheets, you need to follow the below steps.

  • Step-1: On the top right page, click the Open comment history icon
  • Step-2: On the left side of the Comments window, click the “All” drop-down list to filter the comments by any of the following:
    • All
    • For you
    • Open
    • Resolved

add comment google sheets

  • Step-3: All comments in that list will appear in the window

How to Delete a Comment in Google Sheets?

You can always delete a comment which you have added. To delete the comment in the google sheets, you need to follow the below steps.

  • Step-1: Click on the cell that you need to delete the comment
  • Step-2: Click on the More icon and select the Delete option

add comment google sheets

Step-3: Now, click on the Delete button to delete the comment in google sheets.

add comment google sheets

 

Leave a Reply

Your email address will not be published. Required fields are marked *