Collaborate in Sheets - Google Docs Editors Help (2024)

1. Open the file you want to share (that you own or have edit access to).
2. Click Share.
3. Enter the email addresses or groups that you want to share with.
4. Choose what kind of access you want to give people: Editor, Commenter, or Viewer.
5. Click Send.

1. Open the file and click Share.
2. Under Get link, click Copylink.
3. (Optional) To change permissions, click Change, thenchoose Viewer, Commenter, or Editor.
4. Copy and paste the link in an email or any place you want to share it.

1. In Docs, Sheets, or Slides, select the text you'd like to comment on.
2. Click Add comment .
3. Enter your comment in the box.
4. (Optional) To direct your task or comment to a specific person, enter a plus sign (+) followed by their email address. You can add as many people as you want.Each person will get an email with your comment and a link to the file.
5. (Optional) To assign the comment to a specific person, check the Assign to box.
6. Click Comment or Assign.

Note: If a file reaches the maximum number of comments, you can make a copy of the file without copying over any comments.

1. Click FileEmail collaborators.
2. (Optional) To remove a collaborator from the email, uncheck the box next to their name.
3. Add a subject and message.
4. (Optional) To send a copy of the email to yourself, check the Send a copy box.
5. Click Send.

1. Select a range of cells.
2. Click DataCreate a filter.
3. Go to the top of the range and click Filter to see the filter options.

1. Click a cell that has data.
2. Click DataFilter viewsCreate new filter view.
3. In a column header, click a list and select the data you want to filter. Or, in the search box, enter text to search for the data you want to filter.
4. Click OK.
5. In the Name box, enter a name for your filter view.
6. Click DataFilter views to open your filter view anytime.

For more details, see .

With Sheets, you can also turn your data into a table. For more details on converting data to a table, see Use tables in Google Sheets.

1. Open the sheet and click Data > Protected sheets and ranges.
2. Click +Add a sheet or range.
3. Click Range to protect a range of content or Sheet to protect a whole sheet.
4. Click Set permissions and choose whether to show a warning or restrict who can edit the content.
5. Click Done.

1. At the top of the spreadsheet, click Share.
2. At the bottom, click Advanced.
3. Check the Disable options to download, print, &copy for commenters and viewers box.
4. Click Done.