How to Add Notes and Comments in Google Sheets & The Difference

Created by Lynn Shoop, Modified on Mon, Feb 9 at 11:34 AM by Lynn Shoop

How to Add Notes in Google Sheets

  1. Right-click on the cell where you want to insert your note
  2. Move your cursor down and select Insert note
  3. Begin typing your note in the text box and hit Enter when finished
  4. Your note is finished. If you want to see your note, hover over the cell with your pointer



To delete your note, right click on the cell where you want the note removed and select ‘clear notes’.

-----------------------------------------------------------------------------------------

How to Add Comments in Google Sheets

  1. Right-click on the cell where you want to insert the comment

  2. Move your cursor down and select Comment

  3. Enter your comment and press the Comment button when you are finished

  4. You can tag a person in your comment by typing the @ symbol followed by their name

  5. You can also assign a task to a person by clicking the checkbox for ‘assign’

  6. This generates an email to the person you tagged AND the owner of the document


To Delete a Comment

  1. Hover your pointer over the cell with a comment

  2. When the comment appears, click the three dots on the top right of the comment box

  3. Select the delete option

You can also reply to a comment

  1. Hover over the cell and click on the text box

  2. To edit a comments, select the edit option



You can Assign a task 

  1. type @ followed by the person’s name you want to assign the task to

  2. Click in the ‘assign to’ checkbox - this changes the green ‘comment’ button to ‘assign’’

  3. Click ‘assign’

  4. This generates an email to that person



To Mark the Assignment Complete

  1. From your email, click the ‘Mark as Done’ link or

  2. Open the item if you want to view prior to marking as done


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article