Need to create a project schedule? Try our Gantt Chart Template!

New Discussion-Style Comments in Google Spreadsheets Perfect for Collaboration

comments feature in google spreadsheets

When I need to collaborate with somebody on a spreadsheet, such as a project schedule, calendar, or to-do-list, I often use Google Docs. So, when I saw Google's announcement about discussion-style comments, I got really excited.

If you normally use Microsoft Excel, you're probably familiar with what Excel has always referred to as a "cell comment." You can right-click on a cell and select Insert Comment and then add whatever notes you want. This is also how Google Docs worked originally, but now Google has defined those kinds of comments as "Notes" and redefined a cell "Comment" to be more like a discussion thread for a specific cell. The image below compares a comment in Excel 2010 to the new Google spreadsheet comment.

Examples of Comments in Excel and Google Docs

This change by Google really makes a lot of sense, especially given the emphasis that Google Docs places on collaboration. The comments now behave just like the comment threads you see in blogs, forums, and social media.

Each cell can have it's own separate comment thread. You can mark a comment as "resolved" to make the discussion thread no longer pop up when hovering over the cell. But, the comments are not deleted when marked as resolved - all the comments for the spreadsheet are still available by clicking on the Comments button at the top of the document. The following image from the Google Docs help article Overview of comments and discussion shows what the discussion thread looks like when you click on the Comments button.

Discussion Threads via Comments Button

Discussion threads viewed using the Comments button (image from Google Docs support article)

Still a Use for Regular Notes

Comments are for communicating with the other people who are using your document. There are still plenty of reasons for using notes instead of comments.

If you want to include a description for a column heading or use a note to provide more information about a particular cell, you can insert a note by going to Insert > Note. The image below shows an example of a note on a column heading:

Example of a Note added to a cell in a Google spreadsheet

Example of a Note added to a cell in a Google spreadsheet

In case you are concerned about compatibility issues with Excel, if you upload an Excel document to Google Docs, the "comments" in Excel are converted to notes (just what you'd expect).

Use Case: Project Tracking

Project Tracking Template

I recently published a new Project Tracking template designed as a communication tool for a service provider and client to plan and discuss tasks related to some project. This template serves as a perfect example of where the new discussion-style comments might be used.

The example below shows a comment added to a cell that explains why a task was changed to "On Hold" ...

Notifications within a Project Tracking spreadsheet

Comment used as a notification of status change within the Vertex42 Project Tracking Template.

The above image also shows that when a comment is added to a cell, a little notification flag shows up next to the worksheet name with the number of comments in that worksheet. When you hover your mouse over the notification flag, all the comments become visible.

I've added the project tracking template to the Google Docs template gallery. You can find a link to the Google Docs version on the Project Tracking page.

Comments

1 comment… add one
  • Very useful. Well done. More details about Excel:

    On full Excel since [I believe] 2019 (who can tell, since computer-clueless Microsoft now invisibly alters products with 365).

    If a [“traditional”] comment exists on a cell, you (apparently) can’t insert a discussion thread “Note”. The ribbon item is grayed out.

    Three keyboard ways with comments to create/edit: shift-F2; alt-I,M (create only). Third is via review ribbon, alt-R,C (create only) – except that as of September 2021 it faultily creates a Note, not a comment.
    Create Note: ribbon alt-N,C,2
    All of that is in addition to right clicking (shift-F10 for fast workers). However, beware that right-click,N(several times because they faultily multiply assigned ‘N’) claims to insert a Note, but it inserts a comment, as of September 2021.

    You can’t create or edit a Note where a comment exists, and vice versa.

    Remember alt-V-C to [toggle] view all comments. Notes aren’t shown. This is as opposed to ribbon route alt-R,H1 which claims to show comments, but it shows Notes instead, in an intrusive “side pane” (like formerly useful Help does). And what is the title of the intrusive pane? Why “comments”, of course – because it refers to Notes.

    A comment edit and creation is complete by hitting the ESCape key, whereas ENTER adds a linefeed. A Note requires ENTER to save, while ESCAPE lets you out without saving. (An accidental improvement, but beware of the inconsistency between Notes and Comments here.)

    Note that there is now a status bar flyover that faultily says “Cell A1 note by Bob” [if your Excel username is Bob] for a COMMENT as of September 2021. There is now a flyover that faultily says “Cell A1 comment edited by Bob” for a NOTE as of September 2021. That is supremely incompetent, but that’s Seattle for you.

    Note, no statusbar flyover entry occurs if there is already statusbar comment. They got that right; no content is destroyed.

    Reply

Leave a Comment

Your Name will be displayed along with your comment. Your Email and IP address are stored with the comment and used to identify/prevent spam (via a service provided by Automattic.com), but are not shared publicly. See our privacy policy to learn more.