How do I show comments in Google Sheets?

Sharing files and documents is inevitable especially when you’re collaborating on certain projects. This includes adding users or email addresses to specific sheets, docs files, and the like. Thus, giving comments, suggestions, and edits by other peers you’re working with are some of the things that usually happen.

Tutorial

Google Sheets isn’t an exception to that because when you share a specific worksheet with other users, they can also comment on it. Adding them may be easy, but do you know how to view them?

That’s an essential thing you need to learn and so, we’ll teach you all about it in this guide.

1. Open Google Sheets and select the worksheet you wish to check.

Of course, you might already have a lot of completed worksheets or files in your Google Sheets. Thus, make sure to open the right one you need to look at.

2. Go to the specific sheet you need to look into.

Now, you may have multiple sheets in a single worksheet. You’ll see that at the bottom part of your screen, the names of each sheet shows. Click the sheet where you want to view all the comments.

For the example below, I chose to look at the comments on the sheet named “WK33OrderList”.

3. Click the arrow beside the sheet name and select “View Comments”.

Upon clicking the down arrow, read through all the options and hover your cursor into the “View Comments” option.

Or to make it easier for you, simply put your cursor on the sheet name, and a pop-up message similar to what’s encircled in the picture below will show. Notice that there’s a number at the left side of the sheet name. That indicates the total number of comments there is on the page.

Conclusion

After seeing all the comments, you have the option to resolve it once you think that it isn’t necessary there anymore. This feature is a great method that allows communication between you and other peers within the document—it makes everything much more convenient not only for you but for your whole team.

Now that you know about it, you can benefit from this feature by trying it the next time on your Google worksheet!

Comments are a very good way to let the viewers of the sheet know about some specific cells in your sheet. Comments do not have to be too long. Ideally, comments are single-lined or can be of 2-3 lines. You can also see the details of a Google sheets file. We will now quickly move forward with the article to let you learn the main steps.

How to view all the comments in Google Sheets Easily

View Comments in Google Sheets in 6 Steps

Step-1 Open Your Spreadsheet: You first have to open that particular spreadsheet in which you want to add comments. To open the spreadsheet:

• On your device, open its web browser.
• Then, paste the link of your Google sheets file in its search box.
• Hit the 'Enter' key to open it now.

Step-2 Select The Cell To Add Your Comment: Now, you have to click on the cell in which you want to add your comment.

Clicking on the cell will select that particular cell in your spreadsheet.

Step-3 Tap On The 'Insert' Menu: Then, you will have to click on the 'Insert' tab. Insert tab will help you to move forward in this technique without any difficulty.

As you can see in the picture below, you can find this tab at the top of the sheet.

Step-4 Click On 'Comment': You can choose the comment option from this list in two different ways:

• Either simply select the 'Comment' option from the list.
• Or, you can also press the shortcut key 'Ctrl+Alt+M' on your keyboard.

Step-5 Enter the Comment That You Want: Then, in this step, again you have to do the following two things:

• In the text area that appears on the screen as shown, just enter the comment that you want to add in the cell.
• After that, just click on the 'Comment' button which is in green color.

Step-6 Hover Your Pointer onto the Cell to See the Comment: Now, you might possibly wondering if the comment has been added to the cell or not.

To confirm this, all you have to do is just hover the mouse over the cell and it will appear. You can also click on the cell.

FAQ

Why Can I Not See Comments on Google Sheets?

You might be wondering why you are not able to see the comments in your Google sheets file. Let us explain you more about it.

The fact is that you would not be able to see comments in your Google sheets file in the following two cases:

• It you have saved your Google sheets file in PDF format then, it will not show the comments. For that, you should know how to save your Google sheets file in PDF format.
• Also, comments will not be visible if you have uploaded your Google sheet on Google Drive.

How Can I View Comments in Google Docs?

You can view the comments in the Google Docs application in the following steps:

• Open your document in Google Docs.
• Then, click on the 'Comments' button at the top of a Google Doc. It will help you see all the comments and discussions that have taken place in that particular document.

So, instead of scrolling down your document looking for a comment, you can just click on the 'Comments' button at the top of your document which opens up a list summary of all comments.

How Can I Navigate All The Comments in Google Sheets?

If you want to see what all comments are present there in the Google sheet as a whole, then you can follow the simple process which is mentioned by us below:

• Go to the file.
• Then, navigate to the top menu bar.
• Click on the 'Comments' button from there.
• Then, choose the option that says 'Open all comments' item in the sheet tab.
• Then, you can just click on the 'Open' button from any comment anchored to a cell.

Another Method 

Yes, there are comments in Google Sheets also and you can view comments in Google Sheets. But how does it work? Let me explain. In a google sheet, for any cell, you can add comments. Not just you, everyone having access to the sheet can add it. You cannot go through each row and column to find the comments. The following steps will guide you in viewing the comments altogether.

Step-1 Open Google Sheets: First of all, you need to open your google sheets application. Its icon is a green paper folded from the top-right corner. It even has a white-outlined square on top of it. Download it from the play store if you do not have it installed.

• After opening the google sheets you will see a list of your shared and unshared sheets.
• For viewing the comments, open a sheet shared with others.

Step-2 Tap on Any Cell: By opening the Google Sheets, you will all the information that is added by you and others. However, the comments are not visible in plain sight. Tap on any cell to view comments in Google Sheets.

Step-3 Click on the Message Box: On the top-right corner, you will see a message box. It is a rectangular box. It even has three horizontal lines inside it. Just beside the plus sign and before the three-dotted icon you will see this. Tap on that box to view comments in Google sheets.

Step-4 View your Comments: After tapping on the box, you will see the list of all the comments added to the google sheets. In a shared google sheets, it will show the details of who has added the comment and when it was added. The message also is seen completely here. Thus, you can take a quick look at all the comments.

To clarify the location of the comment, tap on any comment in the list of comments. It takes you to the cell where the comment is. It even opens a dialogue box. There you will find various options regarding the comments. A three-dot option will be beside it. By clicking on that, a short drop-down menu appears. You can edit the comment, delete the comment, and also get a shareable link for that specific comment.

• There is also another way to view comments.
• At the top-right corner, you can see a triangular highlight for cells where a comment is there.
• However, it is very small, but visible.
• By clicking on such a cell, a pop-up will appear.
• That pop-up shows a single option of 'view comment'
• Click on that view comment option and your comment is visible.

In the box that appears at the bottom for viewing comments, there are two main things. Firstly, at the top left, there is an option to view all. It will show you all the comments together. Secondly, in the top-middle portion, there are two arrows. One facing left and another facing right. Between them the number of comments is visible. Use arrows to navigate from one comment to another. Thus, you will become a pro at handling, viewing, and managing comments in google sheets.

Why can't I see comments on Google Sheets?

How do I show comments on a spreadsheet?

How do I unhide comments in Google Sheets?