Skip to content
Tutorials Center
My learning

Topics

Lesson 24 of 29 ยท Automation and Collaboration

Sharing, Comments and Version History

Collaborate in Google Sheets: share with the right permissions, comment and assign tasks, protect ranges, and restore earlier versions from history.

A big reason to use Google Sheets is that many people can work in the same file at the same time. You see each other's cursors, edits appear within seconds, and there is no "final_v7_REAL.xlsx" to email around. That convenience needs a few habits: share with the least access that works, discuss in comments instead of typing notes into cells, lock the cells that must not change, and know how to go back when something breaks.

Everything here is done through menus in the real product, so the steps are described in text. Two JavaScript stand-ins model the ideas of permissions and version history. They are teaching models, not the real service.

Working together safely

Share Give the smallest role needed.
Comment Discuss without editing cells.
Protect Lock formulas and headers.
Restore Go back to an earlier version.
1 / 2

Sharing a spreadsheet

Press the green Share button at the top right. You can do two things:

  1. Add people by email address or group. Choose a role for them and optionally send a notification.
  2. Set General access: Restricted (only people you added) or Anyone with the link, again with a role.

The roles are Viewer, Commenter and Editor. A viewer can look and make a copy (unless you turn that off), a commenter can also add comments and suggestions, and an editor can change cells and, by default, share the file with others. The owner is the account that created the file and can also delete it and transfer ownership. In the share settings (the gear icon) you can stop editors from changing permissions or sharing, and you can stop viewers and commenters from downloading, printing or copying.

Good habits:

  • Start with Restricted and name each person. Use Anyone with the link only for non-sensitive data, and set it to Viewer.
  • Prefer Viewer for most people. Give Editor to the few who maintain the data.
  • Set an expiry date on access for temporary collaborators.
  • Share a copy when you want someone to experiment: File โ†’ Make a copy.
  • To let people open the sheet as a read-only copy, replace /edit at the end of the share link with /copy, which makes them copy it instead of editing yours.

Google Sheets cannot run on this page, so these steps are read-only. The code below is a small stand-in model of how roles limit actions, written in JavaScript so you can experiment with the idea.

JS Stand-in: what each role may do

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Comments, mentions and suggestions

To discuss a cell, right-click it and choose Comment (or press Ctrl+Alt+M). A small orange triangle appears in the corner. Type @ and a name to mention someone: they get an email, and if you tick Assign to, the comment becomes an assigned task that stays open until they resolve it. Replies stay in a thread, and Resolve closes it while keeping it in history. The comments button at the top right opens a list of all threads and a filter for those assigned to you.

Comments are different from notes (Insert โ†’ Note, Shift+F2). A note is a plain text label on a cell that anyone with edit access can read, and it has no thread or assignee.

Editors can also switch from Editing to Suggesting mode with the pencil icon at the top right. In suggesting mode the sheet does not change. Instead the proposed edit appears as a comment-like suggestion that the owner or an editor can accept or reject. Use it for review work, for example when an assistant proposes corrections to a price list.

To see who is in the file, look at the avatars in the corner. A colored border with the person's name shows which cell they are editing.

Protecting sheets and ranges

An editor can overwrite a formula by accident. To stop that, use Data โ†’ Protect sheets and ranges. Choose Add a sheet or range, then either:

  • pick a Range (for example the header row or a column of formulas), or
  • pick a whole Sheet, with the option Except certain cells to leave input cells open.

Then press Set permissions. You can show a warning when someone edits the range (they can still continue), or restrict who can edit it to yourself or named people. This is the right tool for "total" columns, lookup tables and headers.

Two cautions. Protection stops edits, but not viewing: anyone who can open the file can read protected cells. And Viewer access never needs it, because viewers cannot edit anyway. For truly private data, keep it out of the shared file.

For input control, combine protection with data validation (see Data Validation and Dropdowns) so that the cells people may edit only accept sensible values.

Version history

Sheets saves your work continuously and keeps a record of changes. Open File โ†’ Version history โ†’ See version history (Ctrl+Alt+Shift+H). The panel on the right lists versions with time and author, and each author has a color. Cells changed in a version are highlighted. Choose a version and press Restore this version to bring it back. Your later edits are not lost, because they stay in the history and you can restore forward again.

You can give important states a name with Name current version (for example "Final budget Q1") and filter the list to Named versions only. Use this before a big clean-up, an import, or sending the file to someone who will edit it. To see the history of one cell, right-click it and choose Show edit history, which lists each earlier value with a name and a time. To recover a copy of an older version without touching the current file, use File โ†’ Version history โ†’ Make a copy from the version panel.

JS Stand-in: a tiny version history

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Other sharing tools

  • Notifications: Tools โ†’ Notification settings can email you when anyone edits or when someone fills in a form.
  • Publish to the web: File โ†’ Share โ†’ Publish to web makes a read-only page or CSV link, visible to anyone who has the link. It is different from sharing, so use it carefully.
  • Download and email: File โ†’ Download (xlsx, csv, pdf) and Email โ†’ Email this file make static copies outside Google's permissions.
  • Filter views (see Sorting and Filtering Data) let each collaborator sort and filter without changing what others see.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. A colleague should read the sheet and leave questions, but not change data. Which role fits?

    Commenters can read and comment but cannot change cells.
  2. 2. What happens to cells in suggesting mode?

    Suggesting mode records the change as a suggestion, so the sheet stays as it was until someone accepts it.
  3. 3. Does protecting a range hide its values from other people who can open the file?

    Protected ranges are still readable by anyone with access. Keep private data out of shared files.
  4. 4. After you restore an older version, what happens to your later edits?

    Restoring is recorded as a new change, and the later versions remain in the history.

Summary

  • Share with named people and the smallest role: Viewer, Commenter or Editor; use link sharing sparingly.
  • Comments with @ mentions and assignments run discussions; notes are plain labels; suggesting mode proposes edits.
  • Data โ†’ Protect sheets and ranges locks cells against edits (not against viewing).
  • Version history keeps named and automatic versions you can inspect, copy or restore.
  • Publishing to the web and downloads leave Google's permission model, so use them deliberately.

Next: Automating with Apps Script