Collaborating with Google Sheets

Collaborating with Google Sheets

Sharing a Spreadsheet File with Other People

Open the file you want to share (that you own or have edit access to). Click Share.

open file

Enter the email addresses or groups that you want to share with. Choose what kind of access you want to give people: EditorCommenter, or Viewer. And then click Send.

share

You can edit access of the sheet that you share with people, by Click Share. Edit your permission or access, and click Done.

access

You can also share your sheet by link, just click Change on the field Get Links.

add-people

Copy link and share it with other people. Choose what kind of access you want to give people: EditorCommenter, or Viewer.

add-people

If you don’t want other people editing your selected sheet, just protected the sheet. By clicking your sheet > Protected the sheet. Give the description of your protected sheet, and click Set permissions. Choose who can editing your sheet, and click Done.

dropdown            protect            restrict

Working with Google Sheets that are Shared with You

Open your invitation, click the button like the picture below:

invitation

The google sheet shared with you automatically opened. You can see what access is given to you, EditorCommenter, or just Viewer. If you are a viewer and you want to edit the sheet, you can request editing access from the owner. And click send.

request

If you are an editor, you can give or change the other person’s access, to be a viewer, commenter, or editor. You can invite more people or share the link.

editor

  • Working with Spreadsheet Revisions

You can view who last edited your spreadsheet by seeing the picture below, you can also view what edited and when by clicking the text.

last edited

Or we can access the history tools by clicking File > Version history > See version history.

history

Your right screen show who have been edited your spreadsheet and when they were edited. We can see the history tools by clicking the time to see what was edited. And you can restore your spreadsheet to the version before by clicking the green button (Restore this version).

restore

  • Commenting on a Spreadsheet

Select the cell you want to comment on. For example, the cell with the word ‘ok’ in the picture, and then click the button inside the round to insert your comment,

comment

Insert your comment, you can tag someone to ask personal by using the ‘@’ and mention the name, and click comment. You can also edit your comment or delete it.

tagall comment

If you want to see all the comments in the spreadsheet, just click the button in the round, you can comment by reply or resolve it.

comment1

Emailing Spreadsheet Collaborator

Firstly, click File > Email > Email Collaborators.

collaborator

Make sure your spreadsheet receiver, and then create the message to your collaborators. Click Send.

email

Your collaborators can see an email like the picture below:

email1

Collaborating Simultaneously and Using Google Chat

You can edit the spreadsheet with other collaborators at the same time, you can see who edited the spreadsheet in that time in the upper right corner of the spreadsheet, if they have not profile picture, just click on the initial and you can see the name.

If the person editing the cell, you can see the highlight with a specific color, match to the color around their profile picture.

highlight

You can also chat with them at the same time to discuss about the spreadsheet by clicking the upper right corner of the spreadsheet, in the round like the picture below:

chat

Sharing is caring

© 2022 All Rights Reserved by Artistudio

Website problem, contact us!