Chat with us, powered by LiveChat

Collaborate

How to Collaborate in Google Sheets

Collaborate

When you're working with others on a shared spreadsheet, everyone with editing permissions will be able to make changes.

When someone else is working in the same spreadsheet as you, you'll see their cell selection, and their changes will appear in real-time.

Add Comments

You can also add comments to a spreadsheet.

  1. Click the cell where you want to add the comment.
  2. Click Insert on the menu bar.
  3. Select Comment.
    Collaborate

    Right-click a cell and select Comment.

    A comment balloon is added off to the side.

  4. Type a comment into the text field and click Comment.
    Collaborate

The comment is added and a comment indicator appears in the upper-right of the cell.

View a Comment

If you see a comment indicator on a cell, you'll want to view the comment text so you can address it as needed.

  1. Point to the cell with the comment.
    Collaborate

The comment appears in a comment balloon.

Reply to a Comment

When someone else adds a comment, it will appear alongside yours. You can see exactly where their comment was added based on what appears highlighted nearby.

  1. Click a comment.
  2. Click in the Reply field.
    Collaborate
  3. Type a reply and click Reply.
    Collaborate

Your reply is added to the comment balloon, forming a thread.

Resolve a Comment

Once you've taken someone's feedback into account and addressed the issue, you can mark a comment as resolved.

  1. Click a comment.
  2. Click the Resolve button.
    Collaborate

The comment is resolved and will no longer appear in the spreadsheet.

FREE Quick Reference

Click to Download