Arrow left
Back to product guides
Google Sheets Tips

How to Tag Someone in Google Sheets

In this article, you will learn how to notify someone of your comments in Google Sheets. The function is helpful when you work with other collaborators on a Google spreadsheet as it makes your communication with others clear and efficient.

How to tag someone in your comments or assignments

  1. Right-click and select “Comment” or press “Ctrl”+”Alt”+M” (for Windows) or “⌘” + “Option” + “M” (for Mac) to open a pop-up window.
  2. Before or after leaving comments, Input “@” mark, and then pick up a name from the name list showing up, or enter an email address directly.
  3. Check the checkbox next to the message “Assign to abc@xyz.com” if you want to make it an assignment. (See below note regarding the difference of the “Comment” and “Assign”
  4. Press the “Comment” or “Assign” button at the bottom left.
How to tag someone in Google Sheet with an example

Note:

  1. A tagged person receives a notification at his email address mentioned in a comment.
  2. The “Comment” function and “Assign” function work similarly, though the “Assign” makes it clearer who is in charge of a task. The difference is that you can leave a comment without assigning the comment to anyone, whereas you can’t add an assignment without tagging anyone.
  3. You can tag more than one person in a comment or an assignment.
  4. Don’t forget to give a person access right to a file as Google Sheets does not give access to the file to the person automatically even if he or she is tagged in the document.

How to close the thread in a comment box

Once you or your collaborator complete the task or a discussion is resolved, you want to close the thread. Here is how to do it.

  1. Put your cursor on the cell including a comment thread you want to end
  2. Click the check mark at the top right corner of the window
  3. The thread is saved in the comment history
How to end a comment thread in Google Sheets

How to see the comment history in Google Sheets

The comment history is the communication records with your collaborators via the comment function. Check this article to learn how to use and leverage the comment history.

Other tips related to notes and comments

If you don’t get the right answer to your question in this article or you have other questions on notes and comments, you may find the answers in the following articles.

Comments

How to Add a Comment to a Cell in Google Sheets

Comment History in Google Sheets: Explained

Notes

How to Insert a Note in Google Sheets

Analyze your live financial data in a snap

Are you learning this tip to build a financial model or financial KPI dashboard? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711