Collaboration in Spreadsheets

In Spreadsheets, several people can work together in the same sheet — all edits are automatically shared in real time. Use permissions, revisions, and comments to create a seamless collaborative environment.

Assigning Permissions

All collaborators must have permission to access a Spreadsheet. If you are an Owner, you can check or grant permissions by clicking Permissions on the File tab.

To learn how to set permissions from Home, see Managing Document Permissions in Wdesk Home.

Assigning Permissions

The Permissions editor shows the current groups and collaborators. Use the search box or scroll down the list to find specific collaborators. You can use the Filter button in the upper right corner of the editor to view collaborators by permission level.

Permissions Editor

There are three permission levels:

  • Owners have full rights to the document and can manage permissions.

  • Editors can make changes to content and formatting.

  • Viewers can look at a spreadsheet but can’t make any changes.

Click the radio button next to a collaborator’s name to give them appropriate access.

To remove permission, hover over a collaborator’s name and click the that appears on the right.

Remove a collaborator

Authorship in Spreadsheets

After you assign permissions, collaborators can work together in a spreadsheet.

With several people working in a spreadsheet, it’s helpful to know which collaborator made changes, such as when you need to create an audit trail. When you are in a spreadsheet, you can see which cells other collaborators are actively working in by the cell outline color.

Color edits

You can also use the Authorship overlay to see which collaborators edited each cell in the current version of the spreadsheet.

To view the Authorship overlay:

1
Click the History icon in the right panel to open the History panel.
2
Click the Authorship toggle to turn on the overlay.

The authorship toggle

The Authorship legend shows each collaborator’s name next to their color. The cell(s) in the spreadsheet change to an author’s color to let you see the most recent edits at a glance.

Authorship overlay example

Revisions

Revisions are groups of edits that are automatically saved every five minutes. From the History panel, you can view revisions to see who made a change and when. Click a revision to see the state of the document at the time of that revision.

The History Panel

Cell History

You can view an individual cell’s history directly in a sheet or from the History panel. When the Authorship overlay is on, you can hover over a cell to see who made the last change.

Collaboration in Authorship

To view a cell's history from the History panel:

1
Click the History icon to open the History panel.
2
Click the arrow in the upper right corner of the panel to see the drop-down menu.
3
Select Cell History.

Cell History

4
From your sheet, select the cell you want to view.

You can toggle between the history of an individual cell and the entire spreadsheet using the drop-down menu in the History panel.

Comments in Spreadsheets

To add a comment in a spreadsheet:

1
Select a cell or group of cells.
2
Right-click the selection and choose Add Comment from the drop-down menu.
3
In the Comment panel, type your comment.
4
Click Post to add your comment.

Add a comment