How to Delete Comment in Google Sheets (2 Possible Ways)

When working on a project in spreadsheets with many users, a lot of comments or notes are created so that any necessary adjustments can be made at any time. The comment may, however, need to be deleted or removed following the change. The option to erase comments is also available on Google Sheets. You can learn how to delete comment from Google Sheets with the help of this article.

A Sample of Practice Spreadsheet

You can copy the spreadsheet that we’ve used to prepare this article.

2 Possible Ways to Delete Comment in Google Sheets

When collaborating, there are basically two possible outcomes. One is that you might need to delete your comment once it has served its purpose, and the other is that you might need to delete comments left by others. To illustrate each option, we’ll use a simple and easy example.
Assume you are gathering information on the physical properties of some boys between the ages of 14 and 15. You’ll see that the top right corner of the cells with comments is marked in yellow.

comment in google sheets table

1. Delete Own Comment

You will also encounter cells with your comments. Check cell C5 in this example, where the owner left a comment. Check out the steps below to learn how to delete it.

  • When you click cell C5, it will be highlighted as seen in the picture.
  • Just next to the cell, a window will appear where you can leave and view comments.

how to select comment in spreadsheet

  • You may detect three dots in the top right corner of the box. When you click it, a menu with three choices, including Edit, Delete, and Get a link to this comment, will drop down.
  • Afterward, if you wish to erase the comment, choose the Delete option.

how to delete comment in google sheets

  • You will receive the following window in response. Its background is transparent black. It will ask “Delete this comment thread?” one last time to confirm.
  • In response, you have the choice to Delete or Cancel.
  • Lastly, select Delete to eliminate the comment.

confirmation message before deleting comment

  • Cell C5 in the table doesn’t have a yellow mark, as you can see. It serves as proof that the comment was removed.

google sheets delete comment

2. Remove Comment of Another User

You might have to deal with feedback from other users. Sometimes you might not have complete authority to delete the comment in this situation. However, you can resolve it. Check out the instructions below (with an image) to learn more about how to remove comment from Google Sheets.

  • First, look at cells E8 and D9, which has a comment that is not from the owner.
  • The cell will be highlighted immediately once more, and a box will show up next to it.

comment of another user

  • However, if you proceed as directed in the previous section by selecting the three dots, you will only have the choice of choosing “Get link to this comment’. For this case, we verified cell D9.

available options for removing comment of another users

  • We will therefore choose the check “” mark in this instance rather than the three dots. As the check mark signifies “Marked as resolved and hide discussion”. Here, we apply this process to cell E8.

Marked as resolved and hide discussion

  • The yellow marks at the top of cell E8 will then be gone, as you can see.

result after marked as resolvedBy simply following these steps, you can hide the comments of other users from google sheets. As you can see, resolving the comment deletes the original comment.

How to Edit Comment in Google Sheets

Google Sheets allows users to edit comments as needed. There are not many steps to take. In the next section, we’ll use images to illustrate the procedure visually.

  • Assume that you will edit the comment in cell C8 as a user. Therefore, you must choose the cell first. Consequently, the comment window will show up right next to the cell.

data for editing comment in google sheet

  • Next, select the three dots in the top-hand corner of the window. A short drop-down window will then show up after that.
  • Now, select Edit.edit option in comment section
  • Immediately after that, the comment will show up in a box with a blue border, and you’ll see that the Save word is initially inaccessible.

blue border box for editing comment in google sheet

  • You are now free to edit as you choose. In this instance, though, we will omit a few words to provide an update, and we’ve made a statement like, “Should be between 14-15.”
  • You will notice that the Save option is now visible following the edit.

accessibility of save option

  • To finish and save the edit, click Save.
  • Finally, you can see the revised and updated comment. The previous comment was no longer visible. Only the edited comment is available.

result after editing comment in google sheets

Final Words

Humans are avid communicators. Successful communication is essential to the success of any project or business. Use your newfound knowledge of how to hide and delete comment to enhance your communication abilities in Google Sheets. For more incredible suggestions, visit OfficeWheel.

Ishrak Khan

Ishrak Khan

Ishrak Khan is a writer and urban planner born in Dhaka, Bangladesh, one of the largest mega-cities. He is a professional Content Developer closely working with OfficeWheel. He simply likes to enthrall his readers. He loves Football, Nico Robin, Deserts, and Twix. If you like the post, give him a heart on Instagram.

We will be happy to hear your thoughts

Leave a reply