Revisions and history allow you to see where changes have been made in your spreadsheet. You can copy content from a previous revision and paste into any current spreadsheet, allowing you to re-use historical content.
View Spreadsheet History
To open the History panel, select the History icon in the far right vertical menu. From the History panel, you can view revisions to see who made a change and when. Revisions are groups of edits that are automatically saved every five minutes.
Creating a spreadsheet automatically creates the first revision. You will see a list of revisions in the History panel for your spreadsheet. The name of the author is visible on the card in the History panel, as well as a small swatch with an assigned color for the author.
Create and Star Milestones
When you hover over a revision, the entry is highlighted and you can click on the arrow on the right to access the Create Milestone option.
Create Milestone allows you to enter a name for the milestone and add remarks. Milestones are used to mark a notable revision for quick reference in the future.
When a milestone is created, an empty star appears in the upper left-hand corner for that revision in the history panel. You can click on the star to add a yellow fill and mark that milestone as significant.
You can filter revisions in the History panel by milestones, starred revisions, time period, and author. This allows you to quickly find important revisions of your presentation.
To filter your revisions:
- Click on the Show Filters icon in the top right corner of the History panel.
- To filter by milestones, check the box to Show Milestones or Show Starred.
- Use the Updated drop-down to filter by time period.
- Enter the name of an author to filter by Author.
To view a cell’s history in the History panel, select Cell History from the drop down in the upper right-hand corner.
From your sheet, select the cell you want to view. The History panel will now show any changes that have taken place in that cell.
When the Authorship overlay is on, you can hover over a cell in the table to see who made the last change.