Collaborate with Google Sheets

1. Collaborate with Google Sheets

Welcome to Module Six: Collaborate with Google Sheets. Google Sheets makes it easy to collaborate with teams, clients, and partners, wherever they are. In this module, we'll look at some of the collaboration options available with Google Sheets, like commenting, action items, and notifications. When collaborating on a Google Sheet spreadsheet, editors and commenters can use comments for discussions and action items. To add a comment, select a cell in the spreadsheet, then select "Comment" from the Insert menu, or click the "Insert comment" toolbar icon. Cells with comments are identified by a small amber triangle in the top right corner of the cell. To reply to a comment, hover over the cell with a comment to reveal the comment card, then click on the card and type a reply. You can also send a comment to a specific person. To do this, mention a person in the comment by typing + or @ before their name, and then choose from the suggested contacts, or type their email address. Select "Comment" to send them a message or add them to the discussion. If they don't have access to the spreadsheet, a prompt will appear where you can choose the appropriate sharing permission to grant them: comment or edit. Remember, you can also use the "Turn link sharing on" option so that anyone with the link to the spreadsheet can comment. If you mention a person when you create a new comment, a checkbox will appear, allowing you to assign the comment to that person as an action item. Checking the box will notify the person and make them responsible for marking it as done. To resolve a comment, select the checkmark on the comment card to mark as resolved and hide discussion. You can also select "More options" to edit a comment or delete it. From the "More options" menu, you can get a direct link to this comment. That link will take collaborators directly to the location in the spreadsheet where the comment was added. As comments are added, edited, and resolved in a spreadsheet, you can view all the comments by selecting "Open comment history" next to the "Share" button. From the comment history, you can view edit, delete, resolve, link to, and reopen comments. Selecting any of the comment cards in the history will move you to the place in the sheet where the comment was added. To manage notifications for comments in the spreadsheet, open the comment history and select "Notifications." Choose which notifications you want to receive. You can choose from "All," "Only yours," or "None."

2. Let's practice!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Google Workspace End User: Google Sheets

BeginnerSkill Level

5.0+

1 reviews

This module covers the agenda. It also introduces students to On the Rise and the course business challenge.

Exercise 1: Course introduction Exercise 2: Agenda

In this module, we will look at the different ways to share your spreadsheets with others. You will learn how to add collaborators and assign them roles and permissions, and also learn how you can share your Google Sheets spreadsheet with a link. You will understand how to transfer ownership of your spreadsheets to another collaborator, track changes, and manage versions.

Exercise 1: Share your Google Sheets spreadsheets Exercise 2: Activity 7 explained Exercise 3: Activity 7 Explore sharing options Exercise 4: Quiz Question 1 Exercise 5: Quiz Question 2