In this article:

How to Show Comments in Google Sheets (2024 Update)

May 8, 2024

How to Show Comments in Google Sheets

Comments in Google Sheets can be viewed individually or all at once. We will explore these methods in the following sections.

How to View Individual Comments in Google Sheets

Step 1: Identify Cells with Comments

Look for cells with a yellow triangle in the upper-right corner. Hover over the cell to reveal the comment without clicking.

google sheets show comments

Step 2: Mark Comments as Completed (Optional)

To mark a comment as completed, click on the checkmark icon in the comment box.

show comments in google sheets

How to Show All Comments in Google Sheets

To view all comments within the spreadsheet, click on the Comments icon located in the upper-right corner of the screen. This will open a sidebar listing all comments. 

how to view comments in google sheets

Alternatively, you can view all comments by either hovering over or clicking on the comments' icon on the sheet tab at the bottom. Clicking keeps the comments open as you navigate the sheet, while hovering hides them again once you move your mouse away.

how to show comments in google sheets

We hope that this article has helped you and given you a better understanding of how to show comments in Google Sheets. If you enjoyed this article, you might also like our articles on how to add comments in a Google Sheets formula and the difference between Google Sheets notes vs comments.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->