What Is Insert Comment In Google Sheets?
Insert Comment in Google Sheets is a feature to save reminders or notes for users, either to recall or keep track of some important information in a shared spreadsheet.
The Google Sheets Insert Comment option helps us to comment on a certain cell value, without changing or altering the value, for the other user to note in case of a shared worksheet.
For example, right-click on any cell, select the “Comment” option, type any comment as required, here, “Hello”, and press “comment” option.
In the above image, we see that the comment is inserted along with the timestamp. We can hover around the cell, where the comment is inserted, to view it anytime.
Key Takeaways
- The Insert Comment in Google Sheets helps users to provide further information on a selected cell value or to start a conversation to discuss doubts or issues.
- It helps us to Insert/Delete, Hide/Show, Edit, Reply/Resolve, etc, the inserted comments, as required.
- It also provides the history of the inserted comments w.r.t the time, date, and the user’s name who added, edited, or replied to the comments, which helps keep track of the modifications.
- When we copy/paste the comments from a cell to multiple cells, if the range of cells selected already had some comments, those comments would be replaced by the comment we are pasting. So, we must be careful not to replace, erase, or delete any comments accidentally.
How To Insert A Comment In Google Sheets?
We can Insert a Comment in Google Sheets in 2 ways, namely,
- Using the Insert tab.
- Using the right-click option.
#Method 1 – Using the Insert tab
Step 1: Select the cell to insert a comment -> select the “Insert” tab -> click the “Comment” option, as shown below.
Step 2: Enter the comment and click the “Comment” or the “Post Comment” button. The comment gets added along with the date and time history.
#Method 2 – Using the right-click option à
Step 1: Right-click on the cell to insert a comment and click the “Comment” option, as shown below.
Step 2: Enter the comment and click the “Comment” or the “Post Comment” button. The comment gets added along with the date and time history.
Shortcut To Insert Comment In Google Sheets
The shortcut keys to Insert Comment in Google Sheets is “Ctrl+Alt+M”.
Examples
We will consider some Insert Comment in Google Sheets examples for the following dataset that consists of employee details, such as names, ID’s, department, the works allocated to them and the details of the allocated work.
Example #1 – Assigning Tasks.
The steps to Assigning Tasks using the Google Sheets Insert Comment feature using the Insert tab optionare:
Step 1: Select any employee, here, John in cell D2 -> select the “Insert” tab -> click the “Comment” option, as shown below.
Step 2: Enter the comment “John please update the details by EOD.” and click the “Comment” option, as shown below.
The comment is added along with the date and time history, as shown below.
Example #2 – Providing Reminders.
In cell E4, we have an existing comment, “Document the ideas of the teammates.”, as shown below.
The steps to Providing Reminders using the Insert Comment in Google Sheets feature are:
Step 1: In cell E4, hover on the comment -> click the vertical three dots on the comment -> click the “Edit” option, as shown below.
Step 2: Once we are in the Edit mode, we can insert more comments or reminders. Therefore, insert another comment, “Reminder 1: Please get it by tomorrow EOD.” in the next line and click the “Save” option, as shown below.
The comment is added along with the existing comment and the old timestamp, as shown below.
However, if we want the updated timestamp to reflect, then add it as a new comment in the same cell or reply to your comment, as shown in the below images.
Example #3 – Using Emoji Reactions.
The steps to Insert Comment in Google Sheets using Emoji Reactions are:
Step 1: Right-click cell F6. Select the “Insert” tabà click the “Comment” option, as shown below.
Step 2: Enter the comment “Let it be lively and we want everyone’s participation.” Click the “Comment” option and the comment is added along with the date and time history, as shown below.
Step 3: In the above image, we can see an emoji at the bottom-right of the comment. When we click that we get the following available options.
Step 4: Click few emojis, any as desired, as shown.
[Note: These emojis can either be what we have clicked, or what others have selected.]
Step 5: Now to view the emoji reactions, got to the comments, click the 3 dots and click the “See emoji reaction details” option, as shown below.
We will see a new window “Comment reaction details”, on the right, with the names of those who acknowledged using the emojis and the respective time, as shown below.
How to Edit, Delete, or Link a Comment in Google Sheets? (with Steps)
Let us learn how we can Edit, Delete, or Link a Comment in Google Sheets.
#Edit ->
Step 1: Cell A3 has an existing comment “abcde”. Click the three vertical dots and select the “Edit” option, as shown below.
Step 2: Now, insert more comments or edit the existing comments. Here, let us add more data “uvwxyz” and click the “Save” option, as shown below.
The edited comment, is shown in the below image.
#Delete ->
Step 1: Cell A3 has an existing comment “abcde uvwxyz”. Click the three vertical dots and select the “Delete” option, as shown below.
Step 2: We will get a dialog box, “Delete this comment thread?” with “Delete” and the “Cancel” options. Here, click the “Delete” option, as shown below.
#Link a Comment in Google Sheets ->
Step 1: Cell A4 has an existing comment “abcde uvwxyz”. Click the three vertical dots and select the “Get link to this comment” option, as shown below.
Step 2: We will get a pop-up, “Link copied to clipboard”, as shown below.
Now, we can save the link by pasting it in the inserted comments or anywhere in the worksheet. Here, I have pasted the link in cell C1 and also in the comments, for our reference, to understand how it appears.
How to Reply to/Resolve a Comment in Google Sheets? (with Steps)
Consider cell A4 that has an existing comment, as shown below.
The steps to Reply to/Resolve a Comment in Google Sheets are as follows:
Step 1: To Reply to a Comment in Google Sheets, on the comment, click @, then we will get the option of our team members. We can select the required person, type a reply and click the “Reply” option, as shown below.
Step 2: To Resolve to a Comment in Google Sheets, click the tick mark that says “Mark as resolved and hide discussion”, as shown below.
[Note: The moment we click the tick mark, the comment is removed from the worksheet. However, to view the comment history in future, we can always check from the “Show all comments” option, as shown below.
Important Things To Note
- The cell comments help communicate ideas, problems, and questions when collaborating on documents. They make the document review/understanding process smoother and faster for everyone involved.
- After entering the text as a comment and clicking on any cell again, the comment gets hidden. But the comment indicator remains on the worksheet name indicating the number of comments in that particular worksheet, as shown below. Each worksheet has one comment, and the Sheet5 worksheet has 3 comments.
Frequently Asked Questions (FAQs)
Yes, there is another way to Insert Comment in Google Sheets.
First, choose a cell -> click the 3 vertical dots, i.e., the “More” option found at the end of the menu bar, as shown below.
The rest of the steps are the same as we learned in this article.
Instead of clicking on the comments one-by-one, we can view all the comments on all worksheets in a workbook as follows:
Select the “View” tab -> click the “Comments” option right-arrow à select the “Show all comments” option, as shown below.
The “Comments” window appears or opens at the right side, where we can click the worksheet tabs and view all the inserted comments, simultaneously. Once done we can use the same path and click the “Hide comments” option, as seen in the image above, to close all the comments.
A few reasons the Insert Comment in Google Sheets may not work are,
a. The inserted comment is modified or deleted.
b. We have added new data and the comments have moved from the existing cell address.
c. The cell values were copy-pasted on an already existing comment cell.
d. We tried to copy paste to multiple cells.
Download Template
This article must be helpful to understand How to Insert Comments in Google Sheets, with its formula and examples. You can download the template here to use it instantly.
Recommended Articles
Guide to Guide to Insert Comments in Google Sheets. We learn how to insert, edit, delete and link a comment with examples and working template. You can learn more from the following articles. –
Leave a Reply